Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 1st 15, 05:55 PM
Junior Member
 
First recorded activity by ExcelBanter: May 2015
Posts: 4
Default 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   Report Post  
Old May 1st 15, 06:59 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,802
Default 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   Report Post  
Old August 19th 20, 09:04 PM
Junior Member
 
First recorded activity by ExcelBanter: May 2015
Posts: 4
Thumbs up

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 View Post
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 04: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


All times are GMT +1. The time now is 02:35 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright ©2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017