My workbook has 26 sheets as pictured below.


On sheet 27 I would like to set up some type of formula that will count the unique dates from all 26 sheets. Dates will always be from A15:A30.


Below example would give a count of 6.


http://i819.photobucket.com/albums/zz111/lacogada/countdates_zps40926dd3.jpg (http://s819.photobucket.com/user/lacogada/media/countdates_zps40926dd3.jpg.html)

Forgot to mention, sheets are as 01, 02, 03,. 10, 11, 12, etc .

This article should help.Excel Count Unique Values (http://www.myonlinetraininghub.com/excel-factor-9-count-unique-items-in-a-list)

You can add a cell in each sheet that counts the unique dates, then have a summary cell to add them from all the sheets.

I point out that B-E inclusively counts as one cell.

Thanks for the reply.

This formula works as long as its on the same sheet.

=SUMPRODUCT(--(FREQUENCY($A$15:$A$30,$A$15:$A$30)>0))

I tried having it look at a different sheet but cannot figure the correct syntax.

With my sheets as 01, 02, 03, etc... I would like the formula below on different sheet.


I get the error message when I try to reference a different sheet.


Anyone see something wrong with the syntax ?




=sumproduct('01'!--(Frequency(a15:a30,a15:a30)>0))

Sheet references must be attached to each range of cell references:


=SUMPRODUCT(--(Frequency('01'!a15:a30,'01'!a15:a30)>0))

Thanks JB