Microsoft Office Forums Sum Product Multiple Text and date Criteria
 Register FAQ Search Today's Posts Mark Forums Read

#1
01-08-2012, 05:45 AM
 ramki Windows XP 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..
M column is Value..
I would like sum the M column..more important any two dates between the dates..
#2
01-09-2012, 01:16 AM
 JBeaucaire Windows XP Office 2003 Advanced Beginner Join Date: Dec 2011 Posts: 51

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.

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post Roscoe Word VBA 7 07-31-2017 04:02 PM Mandusin Excel 8 01-08-2011 02:34 AM galiwock Excel 1 05-12-2010 09:02 AM pureride Word 1 01-05-2010 02:09 PM 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.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top