Hi again All!
I was wondering if any of your lovely, intelligent people out there would be able to suggest a Formula that would enable me to count how many rows meet a set of two criteria, but, accross multipage worksheets.
I have already got the working single page formula to count how many rows meet two criteria, and it appears thusly: " =SUMPRODUCT(--('Client List 2013'!C2:C270=2005),--('Client List 2013'!J2:J270="Yes")) " However, I need the "Client List 2013" toalso include "Client List 2012", "Client List 2011", "Client List 2010", "Client List 2009", "Client List 2008", "Client List 2007", "Client List 2006", "Client List 2005" in both the "2005" section and the "Yes" section. In order to be able to find out how many entries I have that meet the crieteria of "2005" and "Yes" across these 9 Worksheets.
Here's hoping that you can help!
Many Thanks,
Martin
Bookmarks