If A1=10 (columns) and A2=20 (rows)
I want to COUNT cells (with data or blanc) in range B1 : (B1+10,B1+20)
If A1=10 (columns) and A2=20 (rows)
I want to COUNT cells (with data or blanc) in range B1 : (B1+10,B1+20)
Try this formula:
Does that give you the results you're looking for?Please Login or Register to view this content.
If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.
If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.
Yes, with -1 to all ! like A2-1 or A1-1 .....
Thank you !!!!
Well, actualy it doesn't work
Ok, what doesn't work about it? It might be helpful if you can upload a sample workbook.
With "-" between COUNTIF, is what I want !
One count all, one count empty so with "+" I get wrong, I get total + empty , more then I have
It sounds like your cells all have formulas in them, some of which possibly return blanks. Try this formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks