count number of values where corresponding cells are not blank

**ea223** · 01-22-2013, 06:51 PM

i would like a formula that counts the number of values in column A where the corresponding cells in columns B and C are NOT BLANK.
can anyone help?
thank you

**Tony Valko** · 01-22-2013, 06:54 PM

Try this...

=COUNTIFS(A2:A10,"<>",B2:B10,"<>",C2:C10,"<>")

**ea223** · 01-22-2013, 07:03 PM

works perfectly. thank you so much. would you be able to help me with this at all?
http://www.excelforum.com/excel-form...html?p=3093501

**Tony Valko** · 01-22-2013, 07:14 PM

I'll take a look.

count number of values where corresponding cells are not blank

LinkBack

Thread Tools

Rate This Thread

Display

count number of values where corresponding cells are not blank

Re: count number of values where corresponding cells are not blank

Re: count number of values where corresponding cells are not blank

Re: count number of values where corresponding cells are not blank

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions