Home 
Search 
Today's Posts 
#1




Using COUNTIF with criteria in an adjacent column?
Is this possible? I have a structure like this:
A B  5/10 5/10 6/10 5/12 5/25 5/15 5/16 5/30 I'd like to count the number of entries in column A only if the adjacent cell in column B is blank. So, in the example above, I'd want to see a count of 2 as the answer. Can I use the COUNTIF for this, maybe with OFFSET? Or do I need to do a database function? Seems like it ought to be easy, but I'm missing something... Thanks for any help! 
#2




Using COUNTIF with criteria in an adjacent column?
Why not just count the blanks in column B... =COUNTBLANK(B1:B10)
 Jim Cone Portland, Oregon USA . http://www.mediafire.com/PrimitiveSoftware . (free and commercial excel programs) "Mr Molio" wrote in message ... Is this possible? I have a structure like this: A B  5/10 5/10 6/10 5/12 5/25 5/15 5/16 5/30 I'd like to count the number of entries in column A only if the adjacent cell in column B is blank. So, in the example above, I'd want to see a count of 2 as the answer. Can I use the COUNTIF for this, maybe with OFFSET? Or do I need to do a database function? Seems like it ought to be easy, but I'm missing something... Thanks for any help! 
#3




Using COUNTIF with criteria in an adjacent column?
On Jul 29, 11:59*am, "Jim Cone" wrote:
Why not just count the blanks in column B... =COUNTBLANK(B1:B10)  Jim Cone Portland, Oregon USA .http://www.mediafire.com/PrimitiveSoftware. (free and commercial excel programs) "Mr Molio" wrote in ... Is this possible? I have a structure like this: A * * * * *B  5/10 5/10 * * *6/10 5/12 * * *5/25 5/15 5/16 * * *5/30 I'd like to count the number of entries in column A only if the adjacent cell in column B is blank. So, in the example above, I'd want to see a count of 2 as the answer. Can I use the COUNTIF for this, maybe with OFFSET? Or do I need to do a database function? Seems like it ought to be easy, but I'm missing something... Thanks for any help! Thanks, Jim. Let me add a wrinkle to that  the range in both A & B will be changing  expanding or shrinking from day to day. I'd like, in a cell at the top of the sheet, to always be able to tell how many cells in B are blank. Is there a way to use the COUNTBLANK with an expanding range? The range always expands by the user adding to column A, then other users need to go in and fill in values in column B. I need to report each day how many "unfinished" cells there are in Column B. So, could I do something that would basically do this COUNTBLANK (B1: "to the total number of filled cells in A")? I could put a COUNTA(A:A) somewhere else on the sheet, but not sure how to get it's value into the range in the COUNTBLANK function? THanks! C 
#4




Using COUNTIF with criteria in an adjacent column?
Almost missed your response, I usually take the flags off my messages after 4 days. Try this (assumes you may/may not have captions in one or both columns)... =COUNTA(A2:A10000)COUNTA(B2:B10000)  Jim Cone Portland, Oregon USA . http://www.mediafire.com/PrimitiveSoftware . (Data Rows addin: Custom shading, deleting, inserting) "Mr Molio" wrote in message ... On Jul 29, 11:59 am, "Jim Cone" wrote: Why not just count the blanks in column B... =COUNTBLANK(B1:B10)  Jim Cone Portland, Oregon USA .http://www.mediafire.com/PrimitiveSoftware. (free and commercial excel programs) "Mr Molio" wrote in ... Is this possible? I have a structure like this: A B  5/10 5/10 6/10 5/12 5/25 5/15 5/16 5/30 I'd like to count the number of entries in column A only if the adjacent cell in column B is blank. So, in the example above, I'd want to see a count of 2 as the answer. Can I use the COUNTIF for this, maybe with OFFSET? Or do I need to do a database function? Seems like it ought to be easy, but I'm missing something... Thanks for any help! Thanks, Jim. Let me add a wrinkle to that  the range in both A & B will be changing  expanding or shrinking from day to day. I'd like, in a cell at the top of the sheet, to always be able to tell how many cells in B are blank. Is there a way to use the COUNTBLANK with an expanding range? The range always expands by the user adding to column A, then other users need to go in and fill in values in column B. I need to report each day how many "unfinished" cells there are in Column B. So, could I do something that would basically do this COUNTBLANK (B1: "to the total number of filled cells in A")? I could put a COUNTA(A:A) somewhere else on the sheet, but not sure how to get it's value into the range in the COUNTBLANK function? THanks! C 
#5




Using COUNTIF with criteria in an adjacent column?
On Aug 5, 1:24*pm, "Jim Cone" wrote:
Almost missed your response, I usually take the flags off my messages after 4 days. Try this (assumes you may/may not have captions in one or both columns).... * *=COUNTA(A2:A10000)COUNTA(B2:B10000)  Jim Cone Portland, Oregon USA *.http://www.mediafire.com/PrimitiveSoftware*. (Data Rows addin: Custom shading, deleting, inserting) "Mr Molio" wrote in ... On Jul 29, 11:59 am, "Jim Cone" wrote: Why not just count the blanks in column B... =COUNTBLANK(B1:B10)  Jim Cone Portland, Oregon USA .http://www.mediafire.com/PrimitiveSoftware. (free and commercial excel programs) "Mr Molio" wrote in ... Is this possible? I have a structure like this: A B  5/10 5/10 6/10 5/12 5/25 5/15 5/16 5/30 I'd like to count the number of entries in column A only if the adjacent cell in column B is blank. So, in the example above, I'd want to see a count of 2 as the answer. Can I use the COUNTIF for this, maybe with OFFSET? Or do I need to do a database function? Seems like it ought to be easy, but I'm missing something... Thanks for any help! Thanks, Jim. Let me add a wrinkle to that  the range in both A & B will be changing  expanding or shrinking from day to day. I'd like, in a cell at the top of the sheet, to always be able to tell how many cells in B are blank. Is there a way to use the COUNTBLANK with an expanding range? The range always expands by the user adding to column A, then other users need to go in and fill in values in column B. I need to report each day how many "unfinished" cells there are in Column B. So, could I do something that would basically do this COUNTBLANK (B1: "to the total number of filled cells in A")? I could put a COUNTA(A:A) somewhere else on the sheet, but not sure how to get it's value into the range in the COUNTBLANK function? THanks! C Thanks, I'll give it a try. Sorry for not responding sooner  I'm blocked from internet use at work, so I have to pick up what I can in the evenings! 
#6




Using COUNTIF with criteria in an adjacent column?
On Aug 5, 1:24*pm, "Jim Cone" wrote:
Almost missed your response, I usually take the flags off my messages after 4 days. Try this (assumes you may/may not have captions in one or both columns).... * *=COUNTA(A2:A10000)COUNTA(B2:B10000)  Jim Cone Portland, Oregon USA *.http://www.mediafire.com/PrimitiveSoftware*. (Data Rows addin: Custom shading, deleting, inserting) "Mr Molio" wrote in ... On Jul 29, 11:59 am, "Jim Cone" wrote: Why not just count the blanks in column B... =COUNTBLANK(B1:B10)  Jim Cone Portland, Oregon USA .http://www.mediafire.com/PrimitiveSoftware. (free and commercial excel programs) "Mr Molio" wrote in ... Is this possible? I have a structure like this: A B  5/10 5/10 6/10 5/12 5/25 5/15 5/16 5/30 I'd like to count the number of entries in column A only if the adjacent cell in column B is blank. So, in the example above, I'd want to see a count of 2 as the answer. Can I use the COUNTIF for this, maybe with OFFSET? Or do I need to do a database function? Seems like it ought to be easy, but I'm missing something... Thanks for any help! Thanks, Jim. Let me add a wrinkle to that  the range in both A & B will be changing  expanding or shrinking from day to day. I'd like, in a cell at the top of the sheet, to always be able to tell how many cells in B are blank. Is there a way to use the COUNTBLANK with an expanding range? The range always expands by the user adding to column A, then other users need to go in and fill in values in column B. I need to report each day how many "unfinished" cells there are in Column B. So, could I do something that would basically do this COUNTBLANK (B1: "to the total number of filled cells in A")? I could put a COUNTA(A:A) somewhere else on the sheet, but not sure how to get it's value into the range in the COUNTBLANK function? THanks! C Thanks, Jim, that did it! C 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
COUNTIF: 2 criteria: Date Range Column & Text Column  Excel Worksheet Functions  
Using CountIf with nonadjacent cells in same column  Excel Discussion (Misc queries)  
countif = < AND value in adjacent columns match criteria  Excel Worksheet Functions  
summing values from adjacent column with refrence from adjacent column  Excel Discussion (Misc queries)  
Sum column if multiple criteria are met in adjacent cells  Excel Worksheet Functions 