# 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
###### Who is Participating?

Commented:
you mean 25?

use sumifs

=SUMIFS(C2:C4;A2:A4;"=s";B2:B4;"=1")
0

Author Commented:
Oops, yes. 25. Long day. Thank you. I did have to replace the semicolon before the "= with a comma. This worked!
0

Commented:
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)