Date Formula

EvansB2

Board Regular
Joined
Nov 25, 2008
Messages
210
Hi there,

I'm trying to sum certain values that fall within set Date criteria. So using the example below, in cell B6, I would like to only sum those values in column B that fall between the period Apr-19 to Mar-20. So in this case this would be 25,000.

Any assistance would be gratefully received.

Ben


ABC
1CostDate
25000Mar-19
310000Apr-19
415000Aug-19
5
6
7
 

JimM

Well-known Member
Joined
Nov 11, 2003
Messages
631
Try

=SUMIFS(B2:B4,C2:C4,">=01/04/2019",C2:C4,"<=31/03/2020")
 

Forum statistics

Threads
1,085,495
Messages
5,384,010
Members
401,873
Latest member
GCPaul

Some videos you may like

This Week's Hot Topics

Top