Solved can I count a particular nonempty cell of sheets of workbook

July 26, 2012 at 02:48:08
Specs: Windows Vista
I have a work containg no of worksheets, I want to count non empty cell (particular cell) of all sheets in a single sheet.
eg: I have 5 sheets Having same format
A B
1 Date 12/5/2010

I want to count Cell B1 of all sheets if B1 contains a date


Thanks


See More: can I count a particular nonempty cell of sheets of workbook

Report •


#1
July 26, 2012 at 09:42:20
i would look up countifs.

:: mike


Report •

#2
July 26, 2012 at 10:48:49
✔ Best Answer

Report •

Related Solutions


Ask Question