Sumif mutiple criteria

[oli123]

Hi There,

Im looking for some help with the SUMIF function. Im simply looking for a formula that would return a value based on two sets of criteria. Here's an example :

if cell B2 = Canada
AND cell C2 = >20
then i need for cell A2 to return the total sum that's in cell F2

or

if cell B2 = USA
AND cell C2 = >20
then i need for cell A2 to return the total sum that's in cell F3...

Any help would be greatly appreciated.

Thnx,
Oli

 

[Marcelo Branco]

Hi,

Maybe

=IF(AND(B2="Canada",C2>=20),F2,IF(AND(B2="USA",C2>=20),F3,""))

Question: what return do you want if neither condition 1 nor condition 2 are satisfied?

HTH

M.

 

[oli123]

Hi,

Maybe

=IF(AND(B2="Canada",C2>=20),F2,IF(AND(B2="USA",C2>=20),F3,""))

Question: what return do you want if neither condition 1 nor condition 2 are satisfied?

HTH

M.

Thank you Marcelo for your help, this formula seems to be doing the trick! The return value should show $0.00 if condition 1 or 2 are not met.

 

[Marcelo Branco]

Thank you Marcelo for your help, this formula seems to be doing the trick! The return value should show $0.00 if condition 1 or 2 are not met.

You are welcome and tks for the feedback

M.
ps: if you want 0 in the cases conditions 1 and 2 are not met, change the "" at the right-end of the formula to 0