View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gerrie Gerrie is offline
external usenet poster
 
Posts: 13
Default SUMIF giving me 0

I have hours in one column. I have "Y" in second column. I want to total
the hours that only have Y in second column. I find if I switch the columns,
putting Y in the first column & hours in the second column, it works. I
can't switch them though because other people use this spreadsheet & need to
use it as is. Is there a way around this problem?
--
Thanks for any help you can give me.