[dannac]

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.

[dannac]

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

[ScottGem]

This article should help.Excel Count Unique Values

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.

[talaniman]

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

[dannac]

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.

[dannac]

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))

[JBeaucaire]

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


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

[dannac]

Thanks JB