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: 281
Default Sumif with multiple criteria

Hi all,

i have a sheet and want to sum a column with 3 criteria like below:

A B C D
1 date kind1 kind2 amount
2 1/1/2006 silic toronto 10000
3 2/1/2006 Cab Quebec 2000
..
..

i want to sum amounts if dates are less than a date and kind1 is for example
silic and the kind2 is toronto can i use sumif?

any sugestion,

Thanks
--
Farhad Hodjat
 
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
MULTIPLE CRITERIA RETURNING SUM OF RESULTS [email protected] Excel Worksheet Functions 0 November 15th 06 05:11 PM
SUMIF - multiple criteria in different columns SUMIF Multiple Criteria in diff columns Excel Worksheet Functions 1 September 22nd 06 04:06 PM
SUMIF multiple criteria HLS Excel Discussion (Misc queries) 5 March 24th 06 03:43 PM
SUMIF with multiple criteria stacyjhaskins Excel Worksheet Functions 4 August 29th 05 08:22 PM
SUMIF in multiple columns based on other criteria in Excel? Scott Powell Excel Discussion (Misc queries) 9 April 13th 05 02:32 PM


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