counting data with two criterias

Hi,

I need a formula to count the data E9:E281 through to GI9:G281 from the critieria number relating to the supplier in Column A but only over a month period so I can count the data only for each month e.g. Jul E:AI and continue with this through the months happy to change the month data manually.

Cheers,
Jane

Jane

Please read the yellow banner at the top of this page on how to attach a file.

To start with you need to include the identifier in a column in SRS, (have hard coded the 4 ) this could be the number or the name of the company. the data is only for a year the below works,
=SUMPRODUCT(('Manning Info'!$E$9:$BN$22>0)*('Manning Info'!$A$9:$A$22=4)*(MONTH('Manning Info'!$E$5:$BN$5)=7))
=SUMPRODUCT(('Manning Info'!$E$9:$BN$22)*('Manning Info'!$A$9:$A$22=4)*(MONTH('Manning Info'!$E$5:$BN$5)=7))


or
=SUMPRODUCT(('Manning Info'!$E$9:$BN$22>0)*('Manning Info'!$A$9:$A$22=4)*(TEXT('Manning Info'!$E$5:$BN$5,"mmm-yy")=TEXT(T$2,"mmm-yy")))

=SUMPRODUCT(('Manning Info'!$E$9:$BN$22)*('Manning Info'!$A$9:$A$22=4)*(TEXT('Manning Info'!$E$5:$BN$5,"mmm-yy")=TEXT(T$2,"mmm-yy")))

etc

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.