Apple Event: May 7th at 7 am PT
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
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
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
Sum only filtered rows
