Multi-column running summary formula

I need an Excel formula that allows me to calculate If Product = S AND Active = 1 THEN Total = Total + Cost, given this spreadsheet:

        A          B          C        D
1  Product  Active   Cost
2         S            1        12
3         B           0        14
4         S            1        13

The result should be Total = 15 (12 +13 from Rows 2 and 4)

I know I can do this if I create an additional Total column for the row and then sum it up. However, I'd rather not have to create additional columns on this spreadsheet to do so.

Thanks.
LVL 2
c0feeAsked:
Who is Participating?
 
DamjanDemsarConnect With a Mentor Commented:
you mean 25?

use sumifs

=SUMIFS(C2:C4;A2:A4;"=s";B2:B4;"=1")
0
 
c0feeAuthor Commented:
Oops, yes. 25. Long day. Thank you. I did have to replace the semicolon before the "= with a comma. This worked!
0
 
DamjanDemsarCommented:
yes,... semicolon, comma,.... it depends on the local settings, what the delimiter is (mine is a bit unusual as a semicolon.... comma is used as a decimal delimiter here)

I'm glad I could help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.