Forum Discussion
Solved
How to sum the rows cells with a value coressponding?
Hey, there I have an excel file in which I want to sum the value of a row cell corresponding to a condition. see the below image: https://ibb.co/55BRmXr So in the above excel she...
- hey, thanks for helping but I want one last help: if you can add one more condition in it i.e. if a cell has the function sumifs and also the value in the cell is greater than 0 then color it. I mean both conditions must be met then only it color else not.Edit: hey I think i got the solution in conditional formatting with and function: =AND(R1>0, LEFT(FORMULATEXT(R1),7)="=sumifs") #or any function which is in a cell other than sumif can be checked just changing the text and replacing 7 with the formula text length.
Select R5:R701. R5 should be the active cell in the selection.
On the Home tab of the ribbon. select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=ISNUMBER(FIND("SUMIF",FORMULATEXT(R5)))
Click Format...
Activate the Fill tab.
Select light green.
Click OK, then click OK again.
hey, thanks for helping but I want one last help: if you can add one more condition in it i.e. if a cell has the function sumifs and also the value in the cell is greater than 0 then color it. I mean both conditions must be met then only it color else not.
Edit: hey I think i got the solution in conditional formatting with and function: =AND(R1>0, LEFT(FORMULATEXT(R1),7)="=sumifs") #or any function which is in a cell other than sumif can be checked just changing the text and replacing 7 with the formula text length.