Conditional SumProduct

**Paul987** · 12-27-2006, 08:34 PM

I have a spreadsheet set up with 3 columns, A,B and C.
Data in column A is a day of the week, while B and C are numbers.

I need a formula that sums the product(B*C) for one particular day of the week. I would like to do this without first calculating the product in a fourth column.
Any ideas?
TIA, Paul.

**Paul987** · 12-27-2006, 08:41 PM

Got it.
=SUMPRODUCT(--(C2:C21="Monday")*(D2:D21)

This is an adaption of VBA Noob's answer to an earlier question.

I'm not sure how it works, (--)? but it seems to create an array of some sort.
A quick explanation would be nice, but not necessary if you don't feel like handholding.
Thanks again.

**Bryan Hessey** · 12-27-2006, 08:42 PM

Originally Posted by Paul987

I have a spreadsheet set up with 3 columns, A,B and C.
Data in column A is a day of the week, while B and C are numbers.

I need a formula that sums the product(B*C) for one particular day of the week. I would like to do this without first calculating the product in a fourth column.
Any ideas?
TIA, Paul.

Hi,

try

=SUMPRODUCT(--(A1:A200=VALUE("01/01/2001"))*(B1:B200)*(C1:C200))

hth
---amended, 2001"))*