Prev: Why can't I use the MONTH function within the SUMIFS statement
Next: MSNstockquotes option quotes
From: Steve Stad on 29 Mar 2010 10:59 Can you use the 'or' with a countif to count blanks  if so can you tell me how? For example trying to count blanks in a column of data where the range, eg., b1:b100 is blank. ..criteria is something like <A or <1.
From: T. Valko on 29 Mar 2010 11:07 It's not real clear what you want to do. See if this does what you want. =COUNTBLANK(B1:B100) That will count *both* empty cells and cells that contain formula blanks within the range.  Biff Microsoft Excel MVP "Steve Stad" <SteveStad(a)discussions.microsoft.com> wrote in message news:C385250FAB8E477195BA75C951E22A14(a)microsoft.com... > Can you use the 'or' with a countif to count blanks  if so can you tell > me > how? > For example trying to count blanks in a column of data where the range, > eg., > b1:b100 is blank. ..criteria is something like <A or <1.
From: Steve Stad on 29 Mar 2010 12:36 Thanks T Valko, Your answer addressed precisely what I was trying to do. Sorry my question was not as clear. I was not aware of the 'countblank' function. Steve "T. Valko" wrote: > It's not real clear what you want to do. > > See if this does what you want. > > =COUNTBLANK(B1:B100) > > That will count *both* empty cells and cells that contain formula blanks > within the range. > >  > Biff > Microsoft Excel MVP > > > "Steve Stad" <SteveStad(a)discussions.microsoft.com> wrote in message > news:C385250FAB8E477195BA75C951E22A14(a)microsoft.com... > > Can you use the 'or' with a countif to count blanks  if so can you tell > > me > > how? > > For example trying to count blanks in a column of data where the range, > > eg., > > b1:b100 is blank. ..criteria is something like <A or <1. > > > . >
From: T. Valko on 29 Mar 2010 14:14 You're welcome. Thanks for the feedback!  Biff Microsoft Excel MVP "Steve Stad" <SteveStad(a)discussions.microsoft.com> wrote in message news:5697D16E797842C987CA00AD5345830D(a)microsoft.com... > Thanks T Valko, > > Your answer addressed precisely what I was trying to do. > Sorry my question was not as clear. I was not aware of the 'countblank' > function. > > Steve > > "T. Valko" wrote: > >> It's not real clear what you want to do. >> >> See if this does what you want. >> >> =COUNTBLANK(B1:B100) >> >> That will count *both* empty cells and cells that contain formula blanks >> within the range. >> >>  >> Biff >> Microsoft Excel MVP >> >> >> "Steve Stad" <SteveStad(a)discussions.microsoft.com> wrote in message >> news:C385250FAB8E477195BA75C951E22A14(a)microsoft.com... >> > Can you use the 'or' with a countif to count blanks  if so can you >> > tell >> > me >> > how? >> > For example trying to count blanks in a column of data where the range, >> > eg., >> > b1:b100 is blank. ..criteria is something like <A or <1. >> >> >> . >>

Pages: 1 Prev: Why can't I use the MONTH function within the SUMIFS statement Next: MSNstockquotes option quotes 