How do I calculate specific data across worksheets?

[Alus]

I am trying to make a totals page for my information in a workbook. I need to
total how many cells contain specific information. For example, from
worksheet Gwendolyn Kirkland-PM to Rafael Velez-LC, I need to determine if
there was anything in the B4 cell. I believe this is the correct way to do
that :

=COUNTA('Gwendolyn Kirkland-PM:Rafael Velez-LC'!B4)

I now need to determine if there was anything in the B4 cell and count it
only if there is an August date in the C4 cell.

Please help me =(

 

[Don Guillett]

this???
=if(month(mysheet!c4)=8,mysheet!b4,0)

 

[Alus]

No, it didn't work. I am probably not explaining it well enough.

I have 150 worksheets in one workbook which covers a span of 9 months. The
month is written in a merged cell (ABCD) in row 2 in each of the worksheets.
There is a list of 47 services on each worksheet (which starts at B4) which
may or may not have been (1) referred and/or (2) implemented. I need a total
of how many services were referred for each month and how many were
implemented. I am trying to figure out a formula that will count across all
150 worksheets and determine if there is a value in a specific cell (by
month).