Compare date in a range and return sum of 2nd row data array

Yahoho

New member
Joined
Aug 22, 2013
Messages
2
Reaction score
0
Points
0
Hi,

I'm trying to find better way to create formula, that would compare two dates (one is in columns, other in rows) and return sum of second column if date is same and bigger.
See attached example.

Maybe someone has better idea how this formula could be more universal?

Thanks in advance.
View attachment Test.xlsx
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Try:

=SUMIF($C$2:$C$17,">="&G$1,$D$2:$D$17)

copied across
 
Top