Help with a formula

G

Guest

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
 
P

Peo Sjoblom

A couple of ways

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

=SUMPRODUCT(--(A1:A55>8000),--(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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with a formula I am editing 5
if(isna(match formula 8
excel "IF" formula... if this possible ??? 0
i need more help with this time question 5
Referencing a cell even if its contents are moved moved/replaced 6
Copying cell formulas 1
Complex IF 5
Need help with an excel formula 1

Top