LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joel
 
Posts: n/a
Default How do I add multiple values that match multiple conditions?

I have been trying to do this forever. I am using this for sales metrics,
and reporting. Here is the data
Date Rep Revenue Service
01-24-2005 Joel $20 $5
01-24-2005 Bob $22 $7
01-24-2005 Joel $14 $3
01-25-2005 Joel $27 $10
01-25-2005 Joel $22 $11

Ok what I want to do is sum up how much Joel sold on 01-24-2005 ($34), So
the conditions are Joel, and the date. How would you add that up without
adding Bob's numbers in there?
 
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
How to calculate values in multiple values with multi conditions Curtis Excel Worksheet Functions 2 July 15th 05 02:36 AM
SUM based on multiple conditions - SORRY, URGENT!!! marika1981 Excel Worksheet Functions 4 February 18th 05 11:13 AM
How to multiple conditions to validate more than 2 conditions to . Bhuvana Govind Excel Worksheet Functions 1 January 28th 05 07:07 PM
Multiple X-Axis Values Rob Herrmann Charts and Charting in Excel 2 January 23rd 05 10:57 PM
HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ? hims Excel Worksheet Functions 2 October 27th 04 07:03 PM


All times are GMT +1. The time now is 02:40 AM.

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

About Us

"It's about Microsoft Excel"