SUMIF

B

Brad Bross

I have a formula with criteria which excludes "0148" from the sum.
=SUMIF(E$51:E$56,"<>0148",O$51:O$56). I would also like a formula which
would exclude both "0148" and "0101" from the sum. I tried many variations
e.g. =SUMIF(E$51:E$56,"<>0101AND<>0148",O$51:O$56) to get this to work and
cannot obtain the correct results. Thx for your help.

Brad Bross
 
G

Gary''s Student

=SUM(O$51:O$56)-SUMIF(E$51:E$56,"=0148",O$51:O$56)-SUMIF(E$51:E$56,"=0101",O$51:O$56).
 
J

JBoyer

I'm sure there could be simpler ways but you could always just use
=SUMIF(E$51:E$56,"<>0148",O$51:O$56)-SUMIF(E$51:E$56,"=0101",O$51:O$56) .
That should give you the correct results.
 
R

RagDyeR

Try this:

=Sumproduct((E51:E56<>0101)*(E51:E56<>0148)*O51:O56)


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I have a formula with criteria which excludes "0148" from the sum.
=SUMIF(E$51:E$56,"<>0148",O$51:O$56). I would also like a formula which
would exclude both "0148" and "0101" from the sum. I tried many variations
e.g. =SUMIF(E$51:E$56,"<>0101AND<>0148",O$51:O$56) to get this to work and
cannot obtain the correct results. Thx for your help.

Brad Bross
 

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

Standar deviation across sheets help 0
Trying to collapse a table, what Function should I use? 3
SUMIF with criteria "<>" & "=" 4
Summarizing with multiple conditions - Formula solution needed 2
SUMIF result including values not specified in sum-range 3
SUMIFS question 3
sumif with multiple critera range and sum_range 5
sumif error 4

Top