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: 8
Default Sum Multiple Matches

Is there a way to sum totals based on multiple matches? Say in the following
example, from a separate sheet, i want to sum up the totals for stationary on
the first sheet.

e.g.

Expense Type Total
stationary £15
car £140
instruments £150
stationary £25

....so I want to return the 15+25 based on a lookup (assume lookup value to
be a given/stated i.e. "stationary"). Range will be constant size and named
e.g. "JanExpenses"

N.b. there will be 12 sheets, each with similar lists (1 for each month)
which i would then need to sum, so the above might just be for January. I
would then want to add this to Feb-Dec returned totals

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
VLOOKUP and multiple matches tamz33 Excel Discussion (Misc queries) 2 August 14th 07 07:10 PM
Displaying multiple matches mcilwrk Excel Worksheet Functions 7 February 5th 07 05:53 PM
Multiple Matches Carl Excel Worksheet Functions 3 October 3rd 06 02:41 PM
Multiple matches using LOOKUP Sonya795 Excel Worksheet Functions 0 August 9th 05 10:17 PM
Multiple matches on VLOOKUP [email protected] Excel Worksheet Functions 2 May 9th 05 05:15 PM


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