Hello I would like to ask how to SUM only filtered (visible) rows.
I need to sum column C but only rows which contain some number in column B. If column B is "Not selected" it will be filtered out and should not be counted in SUM.
thank you
Mac mini, macOS 10.12
that solves it all ;-) then I can just simply SUM the C column now!
Awesome!
thank you
Wouldn't it make sense to deal with the errors? One approach is to use =IFERROR(<your original formula that causes the error>,"")
SG
SUMIF or SUMIFS are your friend here. More on SUMIFS here. It works with column - condition pairs.
Here is an example using SUMIFS:
=SUMIFS(C,B,"<>"&"Not selected")
You can also Add Category for B.
Click the 'gear icon':
Choose Subtotal:
Giving you something like this:
SG
thank you for your suggestion, but it seams not to work. In my column C I have errors in formula as there is not selected any result so maybe thats why it doesnt work. I need to sum only those rows with the numeric value in column B. Thank you
Wouldn't it make sense to deal with the errors? One approach is to use =IFERROR(<your original formula that causes the error>,"")
SG
that solves it all ;-) then I can just simply SUM the C column now!
Awesome!
thank you
Sum only filtered rows
