Two Sum IF Formulas in one Statement

[merrille]

Hello Everyone,


I am looking to do 2 sum if formulas in one statement can anyone tell me how to get the second half done? I will be using the same data sheet columns the second formula would look like this both work now seperately but I need them both at the same time.



First Statement

=SUMIF(Data!H:H,"ALASKAN",Data!D:D)

Second Statement

=SUMIF(Data!G:G,"RATEING",Data!D:D)


Thanks

merrile

 

[indiantrix]

If your intent is to sum column D whenever column H is "Alaskan" AND column G is "Rateing" then try the following array entered formula:
=SUM((H:H="Alaskan")*(G:G="Rateing")*(D:D))
and enter the formula with Control+Shift+ENTER to make it function as an array formula.
Others likely will offer sumproduct solutions. HTH. Larry

 

[jindon]

try

=Sum(SUMIF(Data!H:H,{"ALASKAN","RATEING"},Data!D:D))

 

[Domenic]

Try...

=SUMPRODUCT(--(Data!$G$2:$G$100="RATEING"),--(Data!$H$2:$H$100="ALASKAN"),Data!$D$2:$D$100)

Adjust the range accordingly. Note that SUMPRODUCT does not accept whole column references.

Hope this helps!

 

[merrille]

Thanks Everyone. I love this board when I use it!