Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Function
Hey All,
Quick questions...hopefully...The formula works great for everything except the '<3' and '20', why? It brings back a '0' for both. Am I suppose to use a different function? I am still pretty new at this so any help would be appreciated. Thanks in advanced My formula is this... =SUMIF(ManualData!H:H,A2,ManualData!G:G) Columns have this in it... ManualData!H:H 3-5 <3 <3 <3 3-5 <3 3-5 <3 6-10 3-5 3-5 6-10 6-10 6-10 20 3-5 A2 <3 ManualData!G:G 13 6 10 9 15 12 10 15 1 20 40 48 10 10 10 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Function
Try it like this:
=SUMIF(ManualData!H:H,"*"&A2,ManualData!G:G) Your criteria, <3, was being evaluated as the logical expression: less than 3. Using the wildcard forces the criteria to be evaluated as the literal TEXT string "<3". -- Biff Microsoft Excel MVP "KS" wrote in message ... Hey All, Quick questions...hopefully...The formula works great for everything except the '<3' and '20', why? It brings back a '0' for both. Am I suppose to use a different function? I am still pretty new at this so any help would be appreciated. Thanks in advanced My formula is this... =SUMIF(ManualData!H:H,A2,ManualData!G:G) Columns have this in it... ManualData!H:H 3-5 <3 <3 <3 3-5 <3 3-5 <3 6-10 3-5 3-5 6-10 6-10 6-10 20 3-5 A2 <3 ManualData!G:G 13 6 10 9 15 12 10 15 1 20 40 48 10 10 10 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Function
yes that solved it.....THANK YOU!!!!!!
"T. Valko" wrote: Try it like this: =SUMIF(ManualData!H:H,"*"&A2,ManualData!G:G) Your criteria, <3, was being evaluated as the logical expression: less than 3. Using the wildcard forces the criteria to be evaluated as the literal TEXT string "<3". -- Biff Microsoft Excel MVP "KS" wrote in message ... Hey All, Quick questions...hopefully...The formula works great for everything except the '<3' and '20', why? It brings back a '0' for both. Am I suppose to use a different function? I am still pretty new at this so any help would be appreciated. Thanks in advanced My formula is this... =SUMIF(ManualData!H:H,A2,ManualData!G:G) Columns have this in it... ManualData!H:H 3-5 <3 <3 <3 3-5 <3 3-5 <3 6-10 3-5 3-5 6-10 6-10 6-10 20 3-5 A2 <3 ManualData!G:G 13 6 10 9 15 12 10 15 1 20 40 48 10 10 10 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Function
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "KS" wrote in message ... yes that solved it.....THANK YOU!!!!!! "T. Valko" wrote: Try it like this: =SUMIF(ManualData!H:H,"*"&A2,ManualData!G:G) Your criteria, <3, was being evaluated as the logical expression: less than 3. Using the wildcard forces the criteria to be evaluated as the literal TEXT string "<3". -- Biff Microsoft Excel MVP "KS" wrote in message ... Hey All, Quick questions...hopefully...The formula works great for everything except the '<3' and '20', why? It brings back a '0' for both. Am I suppose to use a different function? I am still pretty new at this so any help would be appreciated. Thanks in advanced My formula is this... =SUMIF(ManualData!H:H,A2,ManualData!G:G) Columns have this in it... ManualData!H:H 3-5 <3 <3 <3 3-5 <3 3-5 <3 6-10 3-5 3-5 6-10 6-10 6-10 20 3-5 A2 <3 ManualData!G:G 13 6 10 9 15 12 10 15 1 20 40 48 10 10 10 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
Using the TODAY() function in a SUMIF function | Excel Worksheet Functions | |||
How do I use the TODAY function with the SUMIF function? | Excel Worksheet Functions | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |