Payments separeted by months and departments

[ahmetk]

Dear Excel Gurus,

I have a list of payments and I have already sortted them out based on the departments and the suggested value of the payment that is corresponding to that department (data)

I also made a short index file summarizing the sependings. I actually know how to sum different data (Productsum) but in this example I coundn't solve how to correspond dates to months.

In other words all spendings made in month of january should be summed next to Jan.18 and distributed to the related departments (Proje, Kiralama, Genel, Diğer)

At the attachment you may find the study.

Can you please help me how to set different dates of jan as jan only so I can get the sum for that month specific in the index tab? And so on...

Kind regards

AK

 

[vletm]

ahmetk
I found those dates and departments,
but which values should calculate ... ?
Check this ... and modify it for Yourself

 

[ahmetk]

Dear vletm,

Thank you for your kind reply.

Can you please also tell me the formula you have used to calculate sums?

I also want to learn the calculation formula, especially the date part?

Kind regards

AK

 

[vletm]

ahmetk
It's a Pivot-table, no need 'formulas'.
The Date Part is grouped with month and year.

 

[bosco_yip]

Maybe,

In C4, copied across and down :

=SUMIFS(Data!$H:$H,Data!$P:$P,C$3,Data!$C:$C,">="&$B4,Data!$C:$C,"<="&EDATE($B4,1)-1)

Regards
Bosco

 

[ahmetk]

Dear Bosco,

Thank you very much.

Kind regards

AK