Please help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a matrix and I need help on a formula
The formula I am trying to create would be:
=sumif(a1:a100) is greater than 8000 but less than 12000 then
add the figuresfrom b1:b100
eg.
a b
9000 125
7000 85
11995 325
answer would equal 450

thank you
Clinton
 
One way

=SUMPRODUCT(--(A1:A100>8000),--(A1:A100<12000),B1:B100)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top