LinkBack URL
About LinkBacks
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
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)
Posting Permissions
Register To Reply
Bookmarks