I am having my daily transactions as + and - values in single column.
Want to find out the iNcomes and Expenses by month and by payment mode.
Please have a look on the attached file.
I am having my daily transactions as + and - values in single column.
Want to find out the iNcomes and Expenses by month and by payment mode.
Please have a look on the attached file.
Last edited by itsjamaal; 02-17-2022 at 03:39 AM. Reason: Solved by AliGW :)
In K6 copied across and down:
=SUMPRODUCT((MONTH(A$2:A$38=COLUMNS($K1:K1))*(F$2:F$38>0)*(D$2:D$38=$J6)*F$2:F$38))
In K14 copied across and down:
=SUMPRODUCT((MONTH(A$2:A$38=COLUMNS($K1:K1))*(F$2:F$38<0)*(D$2:D$38=$J6)*F$2:F$38))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks for the quickest reply.
I have edited for my convenient as
=SUMPRODUCT((MONTH(DailyDates)=MONTH(K$3))*(Amounts>0)*(PayModes=$J6)*Amounts)
No problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks