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: 74
Default Adjusting a formula to collect data between two dates?

How can modify the formula below so that its criteria is between two dates?

=IF(AF16="",NA(),SUMPRODUCT(--(Date=AF16),Value)

Thank you.
 
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
collect data from mail merge data collection Excel Worksheet Functions 1 November 24th 09 02:19 PM
collect data from one excel sheet to another Sarcalogus Excel Discussion (Misc queries) 3 October 15th 09 05:17 PM
Is there a way to use the P.O. template and collect/store data. Leebob Excel Discussion (Misc queries) 0 April 13th 07 01:46 PM
How to collect data from every 60th row? Jim Ryan Excel Discussion (Misc queries) 2 April 4th 06 05:28 AM
collect data from different worksheet sheva Excel Worksheet Functions 0 August 16th 05 03:22 PM


All times are GMT +1. The time now is 11:24 PM.

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"