Forum Discussion
Solved
can someone advice me on a excel formula (VLOOKUP)
Hi,
I'm struggling to find the right formula in excel.
I have 3 columns: 1 is an amount in euro, 2 is a specified expense and 3 is a period (month).
Now, I would like to make a report in a different TAB showing the total of amount per expense per period.
Anyone?
This can be done with a Pivot Table.
- For getting month wise total, it is better to use sumif in excel for single criteria, and there are multiple criteria use sumifs in excel. Vlookup formula will not give consolidated value for lookup value. Simply use SUMIFS for displlaying month wise and expense wise data.
Thanks This can be done with a Pivot Table.
Vielen DankOliverScheurich
