I have two columns I want to sum up and one condition.
Is there a function to sum both columns without having to combine the two columns?
Ex:
A B C
5 5 active
5 5 cancelled
5 5 active
I want a formula that adds up to 20 based on "active" condition.
Currently, my SUMIF equation would only return 10 from summing up column A only.
Hi
Just add an additional SUMIF. i.e.
=SUMIF(C:C,"Active",A:A)+SUMIF(C:C,"Active",B:B)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
oh cool, thanks!
My pleasure and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks