LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt
 
Posts: n/a
Default help with sumif formula with multiple critera

I cant get this formula to compute what I need. it works perfectly with only
one critera but I need more, We'll say colom A is a date, colom B is a name
and colom I is a value, I need a formula that sums only when the date is X
AND the name is Y. This sheet is used for calculating flight time on specific
tail numbers on specifc days. I an get the formula to work when it is
=SUMIF($B$2:$B$373,M10,$I$2:$I$373) but I cant get it to do both
=SUMIF($a$:$a$373,v10,$I$2:$I$373), where V10 is a specific date, M is the
Name, the date range is in A, and the value is in I

thanks for the help
 
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
SUMif or SUMproduct across multiple worksheets? Eric Shamlin Excel Worksheet Functions 1 September 29th 05 09:55 AM
Sumif with multiple worksheets Cbh35711 Excel Worksheet Functions 3 August 9th 05 02:49 PM
Multiple Condition Sumif Formula momtoaj Excel Worksheet Functions 3 April 6th 05 04:06 PM
Sumif over multiple columns Josh O. Excel Worksheet Functions 1 February 15th 05 04:33 PM
Sum(if ... multiple conditions ... Interpretation? Ken Excel Discussion (Misc queries) 6 December 16th 04 10:23 PM


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