M mart Sep 9, 2009 #1 Can any one help i want to count how many times a number appears in several locations on several spread sheets any ideas?
Can any one help i want to count how many times a number appears in several locations on several spread sheets any ideas?
E Eduardo Sep 9, 2009 #2 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
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
