Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-11-2017, 08:38 AM
NBVC's Avatar
NBVC NBVC is offline Help with a SUMPRODUCT Formula Windows 7 64bit Help with a SUMPRODUCT Formula Office 2007
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default


Why not use the calculated values in column D as you did in your original formula?
Reply With Quote
  #2  
Old 05-15-2017, 01:36 AM
OTPM OTPM is offline Help with a SUMPRODUCT Formula Windows 10 Help with a SUMPRODUCT Formula Office 2016
Expert
Help with a SUMPRODUCT Formula
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
The solution needs to cover a range of dates, not just May. My approach was that if I had the solution for May I could use the same formula for other months.
For example I will have a range of dates from Feb 16 to Dec 17 and I need to calculate the number of days within each date range for each month.
Hope this makes sense.
Thanks
Tony
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Issue with SumProduct Perceptus Excel 1 03-13-2015 06:23 AM
sumproduct?? jer Excel 9 10-14-2012 10:00 AM
Help with a SUMPRODUCT Formula Sumproduct formula Portucale Excel 2 09-12-2012 10:51 AM
Help with a SUMPRODUCT Formula Sumproduct angie.chang Excel 3 06-14-2012 10:00 AM
Help with a SUMPRODUCT Formula sumproduct formula to pull info from multiple sheets Berk21 Excel 7 01-15-2012 11:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:30 AM.


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