Help with a formula

B

boogie

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

if(isna(match formula 8
Looking to added up based on a character from cell range 1
Need to have data in one column 1
Help with a formula I am editing 5
Formula fill series? 1
Dragging a formula 2
Referencing a cell even if its contents are moved moved/replaced 6
Copying cell formulas 1

Top