Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
R
 
Posts: n/a
Default formulas

I have a work sheet that contains a variety of columns. Three columns are of
interest. The first, say A, contains years (2006, 2005, 2004 etc.). The
second column, B, contains Names (Jim, Dick, Bob etc.). The third column, C,
contains a numbers. What I need to do, but I'm having problems figuring it
out is, I want to add the values of column C that meet the criteria of each
column A and B. For example I want to add all the values of C that are 2006
(column A) AND Jim (column B).

I've been playing around with formulas but I haven't managed to figure it
out with trying to match the two columns. If anyone could help or has any
ideas I would appreciate any direction I could get.

Thank you in advance.
 
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
Countif formulas change after doing a sort Bob Smith Excel Worksheet Functions 3 January 3rd 06 11:17 PM
Array Formulas take waaaay too long... belly0fdesire Excel Worksheet Functions 7 August 8th 05 10:11 PM
Problem with named formula's nathan Excel Worksheet Functions 0 January 21st 05 04:07 PM
Way to make Excel only run certain formulas on a worksheet? jrusso Excel Discussion (Misc queries) 0 January 12th 05 04:23 PM
calculating formulas for all workbooks in a folder Chad Excel Worksheet Functions 3 November 13th 04 05:22 PM


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