formula to work with Sumif
 

I need a formula that will look at column A and if meets the criteria then do
a SumIf based on two other columns with another criteria.

formula to work with Sumif
 

=if(A2=criteria,sumif(),whatever you want it to show if doesn't fit criteria)

"Sandy@law" wrote:

I need a formula that will look at column A and if meets the criteria then do
a SumIf based on two other columns with another criteria.

formula to work with Sumif
 

ahh. never mind what I have. I asume you want it to have a rolling
calculation. that's a summproduct, and I don't know the formula off the top
of my head...

"Sean Timmons" wrote:

=if(A2=criteria,sumif(),whatever you want it to show if doesn't fit criteria)

"Sandy@law" wrote:

I need a formula that will look at column A and if meets the criteria then do
a SumIf based on two other columns with another criteria.

formula to work with Sumif
 

Hi,

Maybe something like:

=SUMPRODUCT((A1:A100="John")*(B1:B100="Doe"),C1:C1 00)

HTH
Jean-Guy

"Sandy@law" wrote:

I need a formula that will look at column A and if meets the criteria then do
a SumIf based on two other columns with another criteria.

formula to work with Sumif
 

I was able to work it with

=SUMPRODUCT(--(A:A=criteria),--(B:B=criteria),(C:C))
assuming B is your sumif criteria and c has your sum values.

May work the same as pinmaster's. I'm not sure...

"pinmaster" wrote:

Hi,

Maybe something like:

=SUMPRODUCT((A1:A100="John")*(B1:B100="Doe"),C1:C1 00)

HTH
Jean-Guy

"Sandy@law" wrote:

I need a formula that will look at column A and if meets the criteria then do
a SumIf based on two other columns with another criteria.