Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-08-2012, 05:45 AM
ramki ramki is offline Sum Product Multiple Text and date Criteria Windows XP Sum Product Multiple Text and date Criteria Office 2003
Novice
Sum Product Multiple Text and date Criteria
 
Join Date: Jan 2012
Posts: 1
ramki is on a distinguished road
Default Sum Product Multiple Text and date Criteria

Dear sir,
I tried Sum Product which is Multiple Text and date Criteria and i did not get the correct answer. could you please correct this formula..

=SUMPRODUCT((C7:C450=X7)*((--$B$7:$B$450<=AC3)*(--($B$7:$B$450>=Z3))*(G7:G450=Z6)*(M7:M450)))..

B column is Date


C column is Name..
G column is Grade..
M column is Value..
I would like sum the M column..more important any two dates between the dates..
Reply With Quote
  #2  
Old 01-09-2012, 01:16 AM
JBeaucaire JBeaucaire is offline Sum Product Multiple Text and date Criteria Windows XP Sum Product Multiple Text and date Criteria Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

Try this:

=SUMPRODUCT(--($C$7:$C$450=X7), --($B$7:$B$450<=AC3), --($B$7:$B$450>=Z3), --($G$7:$G$450=Z6), $M$7:$M$450)


That should work, if it doesn't, you're probably having a "matching" error with the dates, perhaps caused by formatting issue that AC3 and Z3 aren't the same format as you column B dates.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum Product Multiple Text and date Criteria Replace text in multiple documents? Roscoe Word VBA 7 07-31-2017 04:02 PM
Sum Product Multiple Text and date Criteria Displaying a date as text Mandusin Excel 8 01-08-2011 02:34 AM
Sum Product Multiple Text and date Criteria how to center text in multiple columns galiwock Excel 1 05-12-2010 09:02 AM
Anyway to determine time/date of text creation? pureride Word 1 01-05-2010 02:09 PM
Sum Product Multiple Text and date Criteria Multiple criteria in SUMIF? pumpkin head Excel 1 02-17-2006 09:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft