June 10, 2021
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!
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?