S.O.S.

F

fuchka

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.
 
K

Kevin Vaughn

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.
Click to expand...

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

Roger Govier

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))
 
Top