LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default sum with multi criteria

I Have 3 columns with like 800 rows
column #1 is the year , column #2 is Codenumder , column #3 is the cost

year code cost
#1 #2 #3
2003 80 500
2001 10 100
2003 230 1000
2002 80 50
2006 10 1500
2003 80 1000

i need to get the cost of the year 2003 that has a codenumber 80
wich here if i do it with my eyes its 1500
how can i make a function for it , to do it for me , even a macro if needed
.<

 
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
Multi Criteria Countif hokiebird2008 Excel Worksheet Functions 3 November 13th 09 09:37 PM
if formula - multi criteria Belinda7237 Excel Worksheet Functions 6 September 3rd 08 03:35 AM
multi-criteria retrievals hoosier41 Excel Discussion (Misc queries) 5 June 18th 08 08:19 PM
Multi Criteria lookup epotter Excel Discussion (Misc queries) 3 July 6th 06 12:32 AM
Multi Criteria then sum lost at work Excel Worksheet Functions 13 June 28th 05 01:00 AM


All times are GMT +1. The time now is 04:53 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"