| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup giving #N/A | Excel Worksheet Functions | |||
| Sumproduct giving #NA | Excel Worksheet Functions | |||
| Giving value to a letter | Excel Worksheet Functions | |||
| Sumif formula not giving result | Excel Discussion (Misc queries) | |||
| SUMIF linked WBs giving OUT OF MEMORY | Excel Worksheet Functions | |||
Hybrid Mode
