LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default I want to add totals using several criteria from different column

I am using excel, on XP 2003 SP2 (might be 3)

I am trying to add amounts together using several criteria. I have a column
called "sales type" (of which there are many types) I then have a column of
the month they are paid (Jan, Feb, Mar, etc.etc.)

I want to show in a cell the sales value of a "sales type" in a given
"month" using a formula instead of selecting each cell manually and adding it
to a simpl addition sum string.

Any help much appreciated!
 
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
Summing totals on separate worksheet based on 2 criteria Cheese_whiz Excel Discussion (Misc queries) 4 January 6th 08 10:34 PM
How do I reorder multiple criteria sub-totals? mad69usa Excel Discussion (Misc queries) 1 August 31st 06 06:10 PM
Return Totals from Certain Criteria JT Excel Worksheet Functions 4 February 21st 06 11:15 PM
Totals based on meeting multiple criteria JerryS Excel Worksheet Functions 3 January 8th 06 09:35 PM
Comparing/matching totals in a column to totals in a row Nicole L. Excel Worksheet Functions 3 January 27th 05 10:42 PM


All times are GMT +1. The time now is 05:51 AM.

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"