| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What am I doing wrong with my =sumif ?
I need to sum the data in column A that meets criteria in column B "=J".
I've settled on SUMIF, but it returns zero. Also, now I need to include the criteria "blank". Am I using the right function? If so, where have I gone wrong? A B 1 1.7 J 2 5.3 U 3 5.3 U 4 5.3 5 5.3 U =SUMIF(B1:B5,J,A1:A5) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple SUMIF formula gone wrong! | Excel Worksheet Functions | |||
| sumif wrong result | Excel Worksheet Functions | |||
| What am I doing wrong? | Excel Worksheet Functions | |||
| nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Threaded Mode
