Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am just learning how to use this function and I want to have the formula
sort through information and add up only certain ones to return a total. For example, I have the following info: 001 210 002 210 003 210 004 210 005 210 007 210 008 210 011 210 013 210 014 210 015 210 017 210 018 210 019 210 613 210 013 215 004 219 005 219 007 219 002 230 003 230 004 230 007 230 012 230 and I want my formula to look for the following criteria in the first column - equal to 001, 002, 003, 004 and 013 and add up those items for the 210 it finds in the second column. thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumif multiple criteria | Excel Worksheet Functions | |||
Sumif with multiple criteria | Excel Discussion (Misc queries) | |||
sumif for multiple criteria | Excel Discussion (Misc queries) | |||
Sumif - multiple criteria | Excel Discussion (Misc queries) | |||
Multiple Criteria for SUMIF | New Users to Excel |