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
 
Try:

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

copied across
 
Back
Top