Forum Discussion
Formula Assistance
I need to add up certain boxes (net expenses) but only if there is a total in a tax box, so I don't pick up any expenses which don't have tax on them. I have no idea how to do it, could someone please advise as to what I would enter?
Hi Hilary,
This is one approach, this adds column A where column B isn't blank
or this option where there are 0 values in column B
Some cosmetic:
=SUMPRODUCT((A3:A5)*(B3:B5<>0))
covers both cases.
For first one
=SUMIFS(A3:A5,B3:B5,"<>")
is enough
