Summing Columns

S

savv32

My question revolves around summing particular items in a column based upon
the number meeting 2 criteria. I have done this before with the sumif
function for one criteria and am wondering how to do this using 2 criteria.
 
R

RagDyer

Depending on exactly what the situations are, you can add your Sumif()
together, or Sum a Sumif() which contains an array constant of criteria, or
use the Sumproduct function.

What are you looking to accomplish?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

savv32 said:
My question revolves around summing particular items in a column based upon
the number meeting 2 criteria. I have done this before with the sumif
function for one criteria and am wondering how to do this using 2
Click to expand...
criteria.
 
B

bj

This is often done using the sumproduct() function
=sumproduct(--(range1 = criteria 1),--(range2 = criteria 2))
the arrays in each section must be the same size but tcannot be the
shorthand for full columns. (A:A won't work)
the "--()" changes the logical true false to a numeric 1 0 for calulations
 
J

JR

=SUMIF(E10:E15,E8,F10:F15)+SUMIF(E10:E15,F8,F10:F15)
This will work. The only thing changed from the first sumif to the second
is lookup value (E8 and F8)
 
A

Ashish Mathur

Hi,

You may use array formulas (Ctrl+Shift+Enter) to get around your problem.

=sum(if((condition 1)*(condition 2), sum to range))

Regards,

Ashish Mathur
 
Top