Yes! Yes! Yes!

I'm so excited -- it really works! :-)

Thank you. It was giving me a headache.

Can I ask a further question; What does the double minus sign, (as in --), in
the formula do?

GBExcel

T. Valko wrote:
Try this...

=IF(BA24="Pay
slip",SUMPRODUCT(--(TEXT(YEARNow!B9:B100,"mmm")=BB23),--(YEARNow!E9:E100="Personal"),YEARNow!H9:H100),"")

Hi,

[quoted text clipped - 32 lines]

GBExcel

--
Message posted via http://www.officekb.com