See
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH
RP
(remove nothere from the email address if mailing direct)
"GateKeeper" wrote in message
...
Perfect. What is the purpose of the "--"?
--
GateKeeper
Experienced Computer User
"David Billigmeier" wrote:
Assume your values are in the range A1:A10, B1:B10 and C1:C10:
=SUMPRODUCT(--(A1:A10="03"),--(B1:B10="S"),C1:C10)
--
Regards,
Dave
"GateKeeper" wrote:
I have a table like this:
Column_A Column_B Column_C
03 S 100
03 T 100
02 S 100
02 T 100
04 S 100
04 T 100
I want to sum the cells in C only when A="03" and B="S". In this
case, I
would expect the total to be 100.