I am repeating a message that I sent earlier, but doesn't appear on my
listing.



A quick and easy cheat or should we say alternative.



Use 3 cells with the formula:

=if(mysubtotal1=0,1,0)

replace the mysubtotal1 with the appropriate cell reference.

If you do not want thesse displayed, colour the font white or the same as
your background colour

Or place the cells off to the right away from the main data.

Remember to set your print area, so Excel does not include them in your
print-outs.





Create a named range say MySubtotals



In the cell that you want to indicate the number of zero subtotals place the
formula:

=sum(MySubTotals)