If date matches - Return value from same row (in a sum if other rows matches too)|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hello!

First of all - I cannot attach my document, as it has sensitive information.

I have a list of costs with dates and I need to make a formula, that matches the dates and returns value in same row.
I've tried VLOOKUP, but just getting a #ref!

So example:

A = Date
B = Cost

So the first one should match the 3 first rows and be = 35,87 + 165,64 + 2,04 
Second one should match the next 3 rows and be = 52,83 + 0 + 38,27

Look in column A for that exact date
Return B in a sum if date is correct.

Hope it makes sense?