View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tflight Tflight is offline
external usenet poster
 
Posts: 8
Default countif vs. if????

Hi,

I am trying to figure out a formula that will calculate the number of cells
that have a number greater than 0 in one cell and then a few columns over has
the word "Low" in it.

Right now, I have COUNTIF(L6:L327,"Low",IF(G6:G327,"0")) and of course I
did something wrong to it because there's an error message.

I'm not sure if explained this welll enough. Please help.....