Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |