ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Count Nonblank Rows based on another cell range meeting specific criteria (https://www.excelbanter.com/excel-discussion-misc-queries/450840-count-nonblank-rows-based-another-cell-range-meeting-specific-criteria.html)

ymadi

Count Nonblank Rows based on another cell range meeting specific criteria
 
Hello,
First time excelbanter user. Good to be here.
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

Thanks for your help
Yasser Madi

Claus Busch

Count Nonblank Rows based on another cell range meeting specific criteria
 
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 (Post 1621016)
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



All times are GMT +1. The time now is 03:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com