LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sumif multiple criteria Chris Cowles Excel Worksheet Functions 9 May 26th 07 11:06 PM
Sumif with multiple criteria Farhad Excel Discussion (Misc queries) 6 December 3rd 06 03:56 AM
sumif for multiple criteria Inter Excel Discussion (Misc queries) 3 May 17th 06 07:17 PM
Sumif - multiple criteria Anat Excel Discussion (Misc queries) 1 July 14th 05 03:01 AM
Multiple Criteria for SUMIF camerons New Users to Excel 3 May 22nd 05 07:01 PM


All times are GMT +1. The time now is 07:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"