ExcelBanter - Excel

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Excel (https://www.excelbanter.com/new-users-excel/242083-excel.html)

Mart

Excel

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

Eduardo

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?

All times are GMT +1. The time now is 07:03 AM.