payment days Table

Hi all,

I will be happy if anyone can help me with creating an excel file that sums the total payments in each currency for every second week tuesday unit by unit ?

let me explain on a sample case:

I have 2 production unit : A; B
They make payments to suppliers on certain periods : p1, p2..
The payments are on variable and different currencies : EUR, SEK, USD, CHF,AUD..

I explained the sample case table in attached excel sheet. My question is "how can i create the summary table easily and quickly by excel?"

currently I am calculating it by a simple excel formula (vlookup) that I need to change the range for each time. It s very time consuming and easy to make mistakes..

thanks in advance, cheers

Hi,

You'd be better advised to list your data as in the attached Sheet3. See table starting in B36.

Then simply analyse the data with a pivot table - see I37

HTH