hi
you might have your sum range and criteria range reversed in the formula.
post your fomula and columns letters of the times and "Y".

Regards
FSt1

"Gerrie" wrote:

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.