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.

SUMIF giving me 0
 

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.

SUMIF giving me 0
 

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.

SUMIF giving me 0
 

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.

SUMIF giving me 0
 

What you are doing wrong is thinking that Excel can guess the "if" column
and the "sum" column. It can't (or more correctly, doesn't). The "if" column
is first, the "sum" column is last. You can't interchange them.

Regards,
Fred.

"Gerrie" wrote in message
...
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.

SUMIF giving me 0
 

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.

SUMIF giving me 0
 

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.

SUMIF giving me 0
 

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.

SUMIF giving me 0
 

Thanks much. That did it.
--
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.

SUMIF giving me 0
 

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.

SUMIF giving me 0
 

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.