Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 10-21-2014, 08:04 AM
gebobs gebobs is offline Average Times on a monthly basis Windows 7 64bit Average Times on a monthly basis Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

I don't know how, but it looks like a parenthesis was moved.

Your sheet's formula starts as:
=IFERROR((SUMPRODUCT(A$8:A$182>=A2)...

That second parenthesis before SUMPRODUCT should be after it:
=IFERROR(SUMPRODUCT((A$8:A$182>=A2)...

Just copy the equation from the post a few above again and paste it again. There is an extraneous space that this forum put in one of the DATE's. I tried to get rid of it, but it keeps appearing.

Probably just better to move the parenthesis.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Average Times on a monthly basis formula for monthly sum paulys Excel 1 08-23-2014 09:44 AM
How do I keep graph sizing and location for reuse on a monthly basis lynchbro PowerPoint 0 06-09-2014 08:06 AM
No monthly view letitbe Outlook 1 09-05-2013 10:25 AM
manipulating borders of a table on a per-border basis gib65 Word 3 05-21-2012 12:40 AM
Average Times on a monthly basis Activating Signature on an ad hoc basis HowardC Outlook 2 03-13-2012 09:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:55 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