Summing 2 columns by date

[JakeMann]

Hi Guys

See attached spreadsheet. Is it possible to have a formula in cell I5 that looks at the date in H4, matches to the dates in A5 and D5 and adds up the cells in B5 and E5

So the answer I should get in I4 would be 5 and in I5 would also be 5.

Thanks

[AliGW]

In I5 copied down:

=SUMIF($A$5:$D$10,H4,$B$5:$E$10)

[AliGW]

I take it that's solved the issue? A 'thank you' woold have been nice ...

You may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.