Hi,
you can try something like

=COUNTIF(A:A,1)+COUNTIF(Sheet2!A:A,1)

Change 1 for the number you are looking for

if this helps please click yes, thanks

"mart" wrote:

Can any one help i want to count how many times a number appears in several
locations on several spread sheets any ideas?