| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel
Can any one help i want to count how many times a number appears in several
locations on several spread sheets any ideas? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
