SOLVED

can someone advice me on a excel formula (VLOOKUP)

Copper Contributor

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?

 

3 Replies
best response confirmed by HansVogelaar (MVP)
Solution

@Pat_B2095 

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
1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

@Pat_B2095 

This can be done with a Pivot Table.

View solution in original post