Double Product IF Formula...I Think........

[davidhall80]

Column A Has Zone 1 through Zone 9. Column B has "New", "Change", or "Old". Column C has Pay Rate. Column D has hours worked. I would like to get total Gross Pay for "Zone 2" "New" assignments. If column A = Zone two, and Column B = New, than multiply C with D and add all those products together. Make sense??....Thanks in advance

 

[yee388]

If your data is in rows 1-100, use something like:

=SUMPRODUCT(--(A1:A100=2),--(B1:B100="New"),C1:C100,D1:D100)

 

[onlyadrafter]

Hello

in F1 enter 2

in G1 enter New

then in H1 enter

=SUMPRODUCT(--($A$1:$A$6=F2),--($B$1:$B$6=G2),($C$1:$C$6)*($D$1:$D$6))

change ranges to suit, you can then add variants in F and G and copy H1 down.

 

[yee388]

Substitute the hard-coded "2" and "New" for cell references if you want to change the lookup variables.

 

[davidhall80]

Got it guys....thanks alot