<div>
Oops, yes. 25. Long day. Thank you. I did have to replace the semicolon before the &quot;= with a comma. This worked!
</div>


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

<div>
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)<br />
<br />
I'm glad I could help
</div>


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

<div>
<div class="content wysiwyg-content">
I need an Excel formula that allows me to calculate If <u>Product = S AND Active = 1 THEN Total = Total + Cost</u>, given this spreadsheet:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; <b> A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C &nbsp; &nbsp; &nbsp; &nbsp;D</b><br />
<b>1 &nbsp;Product &nbsp;Active &nbsp; Cost</b><br />
2 &nbsp; &nbsp; &nbsp; &nbsp; S &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp;12<br />
3 &nbsp; &nbsp; &nbsp; &nbsp; B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp;14<br />
4 &nbsp; &nbsp; &nbsp; &nbsp; S &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp;13<br />
<br />
The result should be <b><u>Total = 15</u></b> (12 +13 from Rows 2 and 4)<br />
<br />
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.<br />
<br />
Thanks.
</div>
</div>


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.

Multi-column running summary formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.