adding figures in adjacent cells next to specified numbers

  • Thread starter Thread starter judoist
  • Start date Start date
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
 
Fantastic...

Thanks

Just one question.

What exactly is the purpose of the two dashes just before or after th
brackets... (--(
 
Oops, misread the req'ts:

=SUMPRODUCT(--(A1:A1000=3),--(B1:B1000>=4),--(B1:B1000<=9),B1:B1000)
 
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
 
Back
Top