Notifications
Clear all
Topic starter
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:
| 01-04-2021 | 35,87 |
| 01-04-2021 | 165,64 |
| 01-04-2021 | 2,04 |
| 02-04-2021 | 52,83 |
| 02-04-2021 | 0,00 |
| 02-04-2021 | 38,27 |
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?
Posted : 11/06/2021 2:58 am
Hi Daniel
Suggest you use a pivot table to group the data then use a VLOOKUP to look for the date and the total cost.
Hope this helps.
Sunny
Posted : 11/06/2021 5:18 am
