About Us

Claus Busch

hi Yasser,

Am Fri, 1 May 2015 17:55:41 +0100 schrieb ymadi:

I’m trying to count the number of nonblank rows in column B where rows
in Column A = 1.1
A B C
1.1 X Formula Returns 3
1.1
1.1 X
1.1 X
2.1 X
2.1
2.1 X

for Excel Version 2007 or later:
=COUNTIFS(A:A,1.1,B:B,"<"&"")
else
=SUMPRODUCT(--(A1:A100=1.1),--(B1:B100<""))

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

ymadi

Thanks Claus Busch!

Sorry for the extremely late reply and thank you. I really thought I had replied in the past.

Quote:

Originally Posted by Claus Busch

hi Yasser,

Am Fri, 1 May 2015 17:55:41 +0100 schrieb ymadi:

I’m trying to count the number of nonblank rows in column B where rows
in Column A = 1.1
A B C
1.1 X Formula Returns 3
1.1
1.1 X
1.1 X
2.1 X
2.1
2.1 X

for Excel Version 2007 or later:
=COUNTIFS(A:A,1.1,B:B,"<"&"")
else
=SUMPRODUCT(--(A1:A100=1.1),--(B1:B100<""))

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count NonBlank Rows with Criteria in another column	[email protected]	Excel Worksheet Functions	7	May 9th 09 03:04 AM
Counting Nonblank cells based on criteria in another cell	[email protected]	Excel Discussion (Misc queries)	2	May 8th 07 03:50 PM
Deleting rows based on data NOT meeting criteria --working macro here, just need help with tweaking	Zarlot531	Excel Programming	4	April 29th 07 12:40 AM
Count no. of nonblank cells in one column based on criteria of ano	Beach Lover	Excel Discussion (Misc queries)	9	February 19th 07 03:39 PM
How do I count nonblank cells that meet criteria in another cell?	jimswinder	Excel Worksheet Functions	13	July 20th 06 04:42 PM

Menu

About Us