Count non-blank cells with condition
Hi everyone!
Its me again. I'd like to count the cells that have criteria like this:
1. have "[+]" symbol in Column A AND
2. it is non-blank cell in Column C.
For example, if user click "[+]" symbol but not enter any item in Column C, the value in D5 should not increase. (You may look at the attachment for better understanding.)
I have tried using COUNTBLANK and COUNTA but it looks like not suitable with this case.
Any help is highly appreciated!
Thanks!
Last edited by isabella; 08-11-2010 at 04:04 AM.
Hi,
How about something along these lines
=SUMPRODUCT((A13:A105="[+]")*(NOT(ISBLANK(C13:C105))))
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Re: Count non-blank cells with condition
Thanks sweep!
It's really help. I appreciate it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks