I have data in A2:C100. I would like one formula in cell C101 that totals column C for any row in which column B + Column A >0. Thank you for your help.
I have data in A2:C100. I would like one formula in cell C101 that totals column C for any row in which column B + Column A >0. Thank you for your help.
=sumproduct((a2:a100+b2:b100>0)*(c2:c100))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks