I want to sum the data in column c if column a= 915 and column c =1001. I
can't get it to recognize the 2nd condition (column c=1001). Please help!

=SUMPRODUCT(--(A1:A10000=915),--(C1:C10000=1001),C1:C10000)

Change the row numbers to fit your data.


--
Regards,
Dave
<!--


"Cheryl W" wrote:

I want to sum the data in column c if column a= 915 and column c =1001. I
can't get it to recognize the 2nd condition (column c=1001). Please help!

=SUMPRODUCT(--(A1:A24=915),--(B1:B241001),--(C1:C24))
Note that 915 can be contained in a cell like
=SUMPRODUCT(--(A1:A24=F1),--(B1:B241001),--(C1:C24))
Regards,
Alan.
"Cheryl W" wrote in message
...
I want to sum the data in column c if column a= 915 and column c =1001. I
can't get it to recognize the 2nd condition (column c=1001). Please
help!

Thank You David!

"David Billigmeier" wrote:

=SUMPRODUCT(--(A1:A10000=915),--(C1:C10000=1001),C1:C10000)

Change the row numbers to fit your data.


--
Regards,
Dave
<!--


"Cheryl W" wrote:

I want to sum the data in column c if column a= 915 and column c =1001. I
can't get it to recognize the 2nd condition (column c=1001). Please help!

Alan,

Thanks very much for providing this solution, it was just the thing I was
looking for as well. However, I can't see how the SUMPRODUCT function is
working in this case. The two minus signs are obviously critical but why?

Can you answer this for me, or point me in the direction of an explanation
please.

Thanks

Carl Sprake
Oxford

"Alan" wrote:

=SUMPRODUCT(--(A1:A24=915),--(B1:B241001),--(C1:C24))
Note that 915 can be contained in a cell like
=SUMPRODUCT(--(A1:A24=F1),--(B1:B241001),--(C1:C24))
Regards,
Alan.
"Cheryl W" wrote in message
...
I want to sum the data in column c if column a= 915 and column c =1001. I
can't get it to recognize the 2nd condition (column c=1001). Please
help!

See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"CarlSprake" wrote in message
...
Alan,

Thanks very much for providing this solution, it was just the thing I was
looking for as well. However, I can't see how the SUMPRODUCT function is
working in this case. The two minus signs are obviously critical but why?

Can you answer this for me, or point me in the direction of an explanation
please.

Thanks

Carl Sprake
Oxford

"Alan" wrote:

=SUMPRODUCT(--(A1:A24=915),--(B1:B241001),--(C1:C24))
Note that 915 can be contained in a cell like
=SUMPRODUCT(--(A1:A24=F1),--(B1:B241001),--(C1:C24))
Regards,
Alan.
"Cheryl W" wrote in message
...
I want to sum the data in column c if column a= 915 and column c
=1001. I
can't get it to recognize the 2nd condition (column c=1001). Please
help!