| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summary Based on Multiple Criteria
I have a portion of a file that has the date, sale and card type. Here is what it looks like: A B C D 1/3/05 $10 VISA 1/3/05 $20 MCARD 1/3/05 $30 MCARD 1/3/05 $10 AMEX 1/3/05 1/4/05 $50 VISA 1/4/05 1/5/05 $30 VISA 1/5/05 $20 AMEX 1/5/05 I created column D which will display a single date at the end of the day when there are multiple sales. What I need to do is get daily totals for the VISA and MCARD together, and keep the total for AMEX separate. The number of transactions on any day can range from 1 to 20. Ideally I would like the data to the right. Any help would be appreciated. Thanks, Phillycheese -- Phillycheese5 ------------------------------------------------------------------------ Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196 View this thread: http://www.excelforum.com/showthread...hreadid=498445 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| count based on multiple date criteria | Excel Worksheet Functions | |||
| SUMIF in multiple columns based on other criteria in Excel? | Excel Discussion (Misc queries) | |||
| Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Threaded Mode
