Summing random days of the month

[Michelle]

I have a workbook with 32 sheets, 1 – 31 and a SUM tab.

On the sum tab I would like to calculate how many times a
sequence of numbers (ex. 1102, 1235, etc) appears,
however, I do not necessarily want to count it each day of
the month, so on the sum take I have a column for start
date and end date. How do I create a formula that
references the start and end days, then sum every time
that 1102 appears on those days / tabs?
Here's an example of how my Sum tab looks:

Unit # Start Date End Date SUM
1102 1 15
1235 5 10
1511 2 22

Thank you.

Michelle

 

[Jason Morin]

If the tabs are named 1,2,3,etc. and the unit #'s appear
in col. A of each tab, you could use:

=SUMPRODUCT(COUNTIF(INDIRECT(ROW(INDIRECT(B2&":"&C2))&"!
A:A"),A2))

where A2 is unit #, B2 = start date, C2 = end date.

HTH
Jason
Atlanta, GA

 

[Michelle]

Thanks for you help.

It does work, however, can you tell me how the formula
reads, I am trying to figure out why it works.

Thanks again.