SUMIF advanced....

[alfgrey]

So im currently using this formula for each month on a balance sheet

=SUMPRODUCT((Wages!$A$2:$A$1000<>"")*(TEXT(Wages!$A$2:$A$1000,"Mmm")=D$6)*(Wages!$E$2:$E$1000))

This works a treat, however in my wages sheet there is another criteria i need it to check before returning a value.

On the wages sheet i enter data for both wages and dividends and the formula returns totals for the given month for both wages and dividends. I want the formula to function as it does now but to only return a total for 'Wages' entries in a given month. On the wages sheet column C is where the row is labelled either "Wages" or "Dividends"

Can this be done? Thanks in advance for any advice.

[Bob Phillips]

Just use

=SUMPRODUCT((Wages!$A$2:$A$1000<>"")*(Wages!$C$2:$C$1000="Wages")*(TEXT(Wages!$A$2:$A$1000,"Mmm")=D$6)*(Wages!$E$2:$E$1000))

[alfgrey]

Many thanks, works a treat.