Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
|
|||
|
|||
Thanks Claus Busch!
Sorry for the extremely late reply and thank you. I really thought I had replied in the past. Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count NonBlank Rows with Criteria in another column | Excel Worksheet Functions | |||
Counting Nonblank cells based on criteria in another cell | Excel Discussion (Misc queries) | |||
Deleting rows based on data NOT meeting criteria --working macro here, just need help with tweaking | Excel Programming | |||
Count no. of nonblank cells in one column based on criteria of ano | Excel Discussion (Misc queries) | |||
How do I count nonblank cells that meet criteria in another cell? | Excel Worksheet Functions |