Sum Product Multiple Text and date Criteria

		Microsoft Office Forums > Microsoft Excel > Excel
Sum Product Multiple Text and date Criteria

FAQ

Thread Tools

Display Modes

01-08-2012, 05:45 AM

ramki

Windows XP Sum Product Multiple Text and date Criteria

Office 2003

Novice

Join Date: Jan 2012

Posts: 1

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..

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Replace text in multiple documents?	Roscoe	Word VBA	7	07-31-2017 04:02 PM
Displaying a date as text	Mandusin	Excel	8	01-08-2011 02:34 AM
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
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 05:52 AM.