ExcelBanter - Help with a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help with a formula (https://www.excelbanter.com/excel-discussion-misc-queries/1384-help-formula.html)

Help with a formula

Hi there
I need help with a formula
The formula I need is probaly very simple.
If cell a1:a55 is 8000 but <12000 add the cells in B1:b55
eg
a1 10000 b1 525
a2 8050 b2 500
a3 12500 b3 628
the answer would be 1025

A couple of ways

=SUMIF(A1:A55,"8000",B1:B55)-SUMIF(A1:A55,"=12000",B1:B55)

=SUMPRODUCT(--(A1:A558000),--(A1:A55<12000),B1:B55)

having said that, didn't you post the same question some time ago?

--
Regards,

Peo Sjoblom

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

"boogie" wrote in message
...
Hi there
I need help with a formula
The formula I need is probaly very simple.
If cell a1:a55 is 8000 but <12000 add the cells in B1:b55
eg
a1 10000 b1 525
a2 8050 b2 500
a3 12500 b3 628
the answer would be 1025