View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NoodNutt NoodNutt is offline
external usenet poster
 
Posts: 221
Default CountIF question

Hi all

Can anyone help with the correct syntax for tha following please.

I need the formula to count all the cells in this exact range that are not
blank.


=countif(not(blank(B8:B11,I7,I9:I11,P7,P8,P10,P11, W7:W9,W11,AD7,AD8,AD9,AD10)))

TIA
Mark.