Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-20-2017, 02:22 AM
Roger Govier Roger Govier is offline sumifs question Windows 10 sumifs question Office 2016
Novice
 
Join Date: Oct 2017
Location: Abergavenny, Wales, UK
Posts: 13
Roger Govier is on a distinguished road
Default

@bjsauer


With your dates in column A, just enter

=SUMIFS(Daily!F:F,Daily!A:A,">="&A2,Daily!A:A,"<"& A3)
and copy down.
The dates will adjust in line with the entries you have made for the date in each row.

Note:
One of your formulae must be just "<" and not "<=" otherwise you are duplicting the value being summed
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with SUMIFS OTPM Excel 8 05-27-2016 07:54 AM
Sumifs lynchbro Excel 1 07-02-2014 09:27 AM
sumifs question Help with SUMIFS LeFoah Excel 2 10-20-2013 09:22 AM
sumifs question I need help with =SUMIFS docwhit Excel 2 01-05-2013 12:58 PM
sumifs question SumIFS Questions Kheinrich119 Excel 2 12-12-2012 10:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:24 PM.


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