Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
  #2  
Old 10-21-2014, 08:10 AM
lynchbro lynchbro is offline Average Times on a monthly basis Windows 8 Average Times on a monthly basis Office 2010 64bit
Advanced Beginner
Average Times on a monthly basis
 
Join Date: Jun 2014
Location: New York
Posts: 41
lynchbro is on a distinguished road
Default

that worked!!

thank you thank you!
Reply With Quote
Reply



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 05:43 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