sumifs question

		Microsoft Office Forums > Microsoft Excel > Excel
sumifs question

FAQ

Thread Tools

Display Modes

10-20-2017, 02:22 AM

Roger Govier Roger Govier is offline

Windows 10 sumifs question

Office 2016

Novice

Join Date: Oct 2017

Location: Abergavenny, Wales, UK

Posts: 13

@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

« Previous Thread | Next Thread »

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
Help with SUMIFS	LeFoah	Excel	2	10-20-2013 09:22 AM
I need help with =SUMIFS	docwhit	Excel	2	01-05-2013 12:58 PM
SumIFS Questions	Kheinrich119	Excel	2	12-12-2012 10:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:03 AM.