View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jo-Anne Jo-Anne is offline
external usenet poster
 
Posts: 1
Default SUMIF, multiple criteria

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