I just went back to the spreadsheet and I re-entered the last few hours again
and then the calculation worked! I don't understand why I would have had to
enter the data again. That's a mystery.
--
Thanks for any help you can give me.


"Gerrie" wrote:

Well, when you gave me a response all was well. Today I just decided to
check one of the files where I'm using this SUMIF formula. The SUMIF formula
calculates to 10 hrs. and manually by me to 12.5 hours. I've redone the
formula twice, but it's still calculating wrong. What could be the problem?
--
Thanks for any help you can give me.


"Fred Smith" wrote:

Your first range is incorrect. It contains two columns rather than one. Try
it this way:
=SUMIF(S816:S820, "y" ,R816:R820)

Regards,
Fred.


"Gerrie" wrote in message
...
Don't know how, but I'll try this:

Column R lists 8 in each cell in four rows
Column S lists y in each cell in four rows (same rows as R column)

Formula is:
SUMIF(R816:S820, "y" ,R816:R820)

I get zero and want to get 32. If I switch data and put y in the R column
and 8 in the S column, and show formula reversed, I get the total



--
Thanks for any help you can give me.


"Per Jessen" wrote:

The problem may be in your formula. It should look like this:

SUMIF(Cells to test, Condition, Cells to sum)

Post your formula for further help.

Regards,
Per

"Gerrie" skrev i meddelelsen
...
It doesn't work unless I switch the hours column with the Y column.
Then
it
works. I would think this would work whichever side either column is
on.
what am I doing wrong?
--
Thanks for any help you can give me.


"Per Jessen" wrote:

With hours in column A and Y in column B, this formula should do it:


=SUMIF(B1:B13,"Y",A1:A13)

Regards,
Per

"Gerrie" skrev i meddelelsen
...
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.