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.