| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula not giving me the right result
Hello from Steved
This formula give me the right result. SUM(H273:H312) This formula give me a different answer. SUMIF($C$6:$C$2000,"PAPAKURA DEPOT",H$2:H$2000) How can I get the formula to give me the result. Thankyou. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula not giving me the right result
The ranges are not the same size. Typo?
"Steved" wrote: Hello from Steved This formula give me the right result. SUM(H273:H312) This formula give me a different answer. SUMIF($C$6:$C$2000,"PAPAKURA DEPOT",H$2:H$2000) How can I get the formula to give me the result. Thankyou. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula not giving me the right result
Hello JMB from Steved
Papakura Depot appears from row 6 to row 2000 it is their 29 times in this range in Column C The objective is to look for Papakura Depot in Column C and sum the Column H. Hopefully I've explained my issue. Cheers. "JMB" wrote: The ranges are not the same size. Typo? "Steved" wrote: Hello from Steved This formula give me the right result. SUM(H273:H312) This formula give me a different answer. SUMIF($C$6:$C$2000,"PAPAKURA DEPOT",H$2:H$2000) How can I get the formula to give me the result. Thankyou. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula not giving me the right result
Yes, but your formula as posted is searching C6:C2000, but is summing H2:H2000
"Steved" wrote: Hello JMB from Steved Papakura Depot appears from row 6 to row 2000 it is their 29 times in this range in Column C The objective is to look for Papakura Depot in Column C and sum the Column H. Hopefully I've explained my issue. Cheers. "JMB" wrote: The ranges are not the same size. Typo? "Steved" wrote: Hello from Steved This formula give me the right result. SUM(H273:H312) This formula give me a different answer. SUMIF($C$6:$C$2000,"PAPAKURA DEPOT",H$2:H$2000) How can I get the formula to give me the result. Thankyou. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula not giving me the right result
Posted before finishing my thought,
with the range sizes mismatched, the numbers returned from column H will be off by 4 rows A match in C6 will return H2 A match in C50 will return H46 "Steved" wrote: Hello JMB from Steved Papakura Depot appears from row 6 to row 2000 it is their 29 times in this range in Column C The objective is to look for Papakura Depot in Column C and sum the Column H. Hopefully I've explained my issue. Cheers. "JMB" wrote: The ranges are not the same size. Typo? "Steved" wrote: Hello from Steved This formula give me the right result. SUM(H273:H312) This formula give me a different answer. SUMIF($C$6:$C$2000,"PAPAKURA DEPOT",H$2:H$2000) How can I get the formula to give me the result. Thankyou. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula not giving me the right result
Thankyou.
You know I looked at it for about ten minutes and did not see what you have seen. Thankyou for taking timeout. Cheers. "JMB" wrote: Posted before finishing my thought, with the range sizes mismatched, the numbers returned from column H will be off by 4 rows A match in C6 will return H2 A match in C50 will return H46 "Steved" wrote: Hello JMB from Steved Papakura Depot appears from row 6 to row 2000 it is their 29 times in this range in Column C The objective is to look for Papakura Depot in Column C and sum the Column H. Hopefully I've explained my issue. Cheers. "JMB" wrote: The ranges are not the same size. Typo? "Steved" wrote: Hello from Steved This formula give me the right result. SUM(H273:H312) This formula give me a different answer. SUMIF($C$6:$C$2000,"PAPAKURA DEPOT",H$2:H$2000) How can I get the formula to give me the result. Thankyou. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula not giving me the right result
You are most welcome.
"Steved" wrote: Thankyou. You know I looked at it for about ten minutes and did not see what you have seen. Thankyou for taking timeout. Cheers. "JMB" wrote: Posted before finishing my thought, with the range sizes mismatched, the numbers returned from column H will be off by 4 rows A match in C6 will return H2 A match in C50 will return H46 "Steved" wrote: Hello JMB from Steved Papakura Depot appears from row 6 to row 2000 it is their 29 times in this range in Column C The objective is to look for Papakura Depot in Column C and sum the Column H. Hopefully I've explained my issue. Cheers. "JMB" wrote: The ranges are not the same size. Typo? "Steved" wrote: Hello from Steved This formula give me the right result. SUM(H273:H312) This formula give me a different answer. SUMIF($C$6:$C$2000,"PAPAKURA DEPOT",H$2:H$2000) How can I get the formula to give me the result. Thankyou. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The Formula is displaying, not the result | Excel Discussion (Misc queries) | |||
| Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Hybrid Mode
