S.O.S.
 

I am a beginner in Excel and need help with this.

In Column "A" I have product prices, In Column "B" I have product codes
and in column "C" I have month values.

I can't get Excel to do following:

Check column C for appropriate month (example: 1) and then check column
B for certain code (example: 1001) and finally to check all values in
column A which match criteria (B&C) and to SUM it.

Please advice.

H.

S.O.S.
 

In Column "A" I have product prices, In Column "B" I have product codes
and in column "C" I have month values.

I can't get Excel to do following:

Check column C for appropriate month (example: 1) and then check column
B for certain code (example: 1001) and finally to check all values in
column A which match criteria (B&C) and to SUM it.

try something like: =sumproduct(--($c$2:$c$10 = 1), --($b$2:$b$10 = 1001),
($a$2:$a$10))

--
Kevin Vaughn


" wrote:

I am a beginner in Excel and need help with this.


Please advice.

H.

S.O.S.
 

it kinda didn't work :unsu

S.O.S.
 

Hi

If you have dates in column C then you would need to amend Kevin's
formula very slightly to

=sumproduct(--(month($c$2:$c$10) = 1), --($b$2:$b$10 = 1001),
($a$2:$a$10))


--
Regards

Roger Govier


"fuchka" wrote in message
ups.com...
it kinda didn't work :unsu