Sumproduct another condition

[blossomthe2nd]

Hi there

I am using the below formula to Sum number of accounts in column C when the date in column A is in May.

=SUMPRODUCT((MONTH(A2:A6)=5)*(C2:C6))

I wish to add another condition so If its may and Column B = "YES" then sum Column C,

Can anyone please help ?

Also is there a restriction to the amount of Conditions that excel can use in these type of formulas ?

Thanks
Anne

 

[blossomthe2nd]

Sorry I realised part my error,

The cells were not formatted correctly as the Merged Cells are from Row 4 , Have changed my formula accordingly, and it is bringing back the total SUM of the results ( hence, Sumproduct I assume!!)

Is there a version of this that COUNTS ?

Thanks

 

[VoG]

This would count

=SUMPRODUCT(--(MONTH('[1.MASTER LOG]Drawdown'!$B2:$B1000)=2),--('[1.MASTER LOG]Drawdown'!$O2:$O1000="NO"))

 

[blossomthe2nd]

Yes it does, I understand !!!

Thanks so much Happy weekend to you

 

[VoG]

Thanks so much Happy weekend to you

And to you. Here's something to read http://www.xldynamic.com/source/xld.SUMPRODUCT.html