Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Please help
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 |
#2
|
|||
|
|||
One way
=SUMPRODUCT(--(A1:A1008000),--(A1:A100<12000),B1:B100) -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "boogie" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|