TOTAL-SUM AS PER MONTH & YEAR FOR THE AMOUNTS WHEN STATUS CHANGES TO CASH OR DEPOSIT
=SUM(SUMIF(B6:R6:B11:R11:B16:R16,{"Deposit","Cash"},B3:R3:B8:R8:B13:R13)) ====THIS IS MY FORMULA WORKING FOR ALL the cell total whenever the status is cash or deposit but I want to do this formula with one more criteria as per months and year, THIS FORMULA SHOULD ALSO SPERATE MONTHS AND YEAR THEN ADD IN TOTAL.
the DATE ROW is A4,A9,A14 BUT THIS DATE ARE NOT FIXED IN CELL IT CAN BE CHANGE IF WE CAN DO SOMETHING WITH RANGES WITH MY FORMULA THEN IT WILL BE MUCH BETTER.
=SUM(SUMIF(B6:R6:B11:R11:B16:R16,{"Deposit","Cash"},B3:R3:B8:R8:B13:R13))
PLEASE FIND THE ATTACHEMENT YOU WILL FIND HOW ITS WORKING .
I TRIED BY BEST TO EXPLAIN EVERYTHING ?
Bookmarks