Excel

M

mart

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel --> Word 4
Publisher adding blank page when printing my booklet... 2
Update several ppt documents from a single excel file 0
Adding data to MS Access from csv file 0
Text duplication question 0
Bugs in Office 2019 0
Section and Page numbering 0
How can the font and size of (all) citation numbers be altered? 1

Top