Count across multiple worksheets

[CatRoberts]

Hi there,

I've created a workbook and need to count the number of cells containing letters across the same row in the 12 worksheets.

My formula so far is:

=COUNTIFS(October!B5:AF5,"=V",November!B5:AF5,"=V")

I need to include all the months of the year (12 worksheets)

The formula will calculate correctly if I have only one month, i.e one worksheet, but when I add more it stops counting?

I'm very much a novice at excel, but what am I doing wrong? I thought i'd cracked it

Many thanks for your help

Cat

 

[Aladin Akyurek]

No... it doesn't work. It counts both vital part ,A and gives the count as 2.

A cell in column B in a given sheet cannot be Vital Part AND A at the same time. That is, why I thought counting occurrences of either Vital Part or A.

Try to post B5:B55 of one of the sheets that you have along wih the desired count for that sheet.