Dear Friends,
A formula needed for..
D14=COUNTA(D7:D12)
where in range D7:D12, I want to count all cells having data, except cell containing "VACCANT".
Please give me a formula.
Thanks in advance
Senjuti
Dear Friends,
A formula needed for..
D14=COUNTA(D7:D12)
where in range D7:D12, I want to count all cells having data, except cell containing "VACCANT".
Please give me a formula.
Thanks in advance
Senjuti
Last edited by senjuti.sarkar; 03-09-2012 at 02:01 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks