Excel Questions

[The_KiD]

I have a couple of Excel questions:

1) Is there a way to have a cell that counts the number of worksheets in the workbook?

2) Lets say I have 100 worksheets in each is a list of results saying either "not found" or the name of a file.

I want to count the number of "not founds" in each sheet, and the number of file names as found files.

E.g. Not Found: 150
Found: 230

If that second one makes sense I am amazed

 

[The_KiD]

Ok have managed number 1


and am on my way to working out number 2, but have a problem with if statements inside a count.

=COUNT(IF(Sheet2!D2<>"no virus found",1,0),IF(Sheet3!D2<>"no virus found",1,0))

Each of the IF statement returns a 1 or 0 depending on whether the words "not found" are in the cell they are checking.

I have checked the if statements individually and they work, but the count returns 2 no matter what it says in the field.



Anyone any good with this sort of stuff?

 

[The_KiD]

lol ignore this post, used SUM instead of COUNT