adding figures in adjacent cells next to specified numbers

J

judoist

I have two columns. One with single digits (0-9), the other has number
but also contains x's plus blank spaces.

Each time the number 3 appears in column 1 i'd like to add the value o
the corresponding figure in column 2 and get a total at the end.

Is it also possible to do this and set numerical limits. For example
each time 3 appears in column 1, add column 2 figure if it fall
between 4 and 9?

Thanks in advanc
 
J

judoist

Fantastic...

Thanks

Just one question.

What exactly is the purpose of the two dashes just before or after th
brackets... (--(
 
J

JE McGimpsey

Oops, misread the req'ts:

=SUMPRODUCT(--(A1:A1000=3),--(B1:B1000>=4),--(B1:B1000<=9),B1:B1000)
 
F

Frank Kabel

Hi
they coerce the boolean values to real numbers (TRUE=1/FALSE=0)
you could aslo multiply with '1' or add '0'. Just use a mathematical
operatioon 8like a double minus) which does not change the result
 
Top