Quote:
Originally Posted by jeffreybrown
Out of curiosity, if I picked "BUSINESS SUPPORT" and equal your month of May, what answer do you expect?
I get 21 if I also understand your requirements.
=SUMPRODUCT(--(MONTH($C$1)=MONTH(Sheet1!$E$6:$E$14)),--($A3=Sheet1!$A$6:$A$14),Sheet1!$I$6:$I$14)
and this is in column E opn the Skillset Availability tab
|
Hi Jeffrey
That works perfectly, many thanks. Just one final request "how do I add the Year to each MONTH part of the equation" as my ranges will span two years as a minimum?
Thanks again for your feedback.
Tony