TOTALSUM AS PER MONTH & YEAR 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.
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.
I TRIED THIS IT NOT WORKING
=SUM(SUMIF(B6:R6:B11:R11:B16:R16,{"january(H4:X4:H9:X9:H14:X14)=1","Deposit","Cash"},B3:R3:B8:R8:B13:R13))
=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.
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.
I TRIED THIS IT NOT WORKING
=SUM(SUMIF(B6:R6:B11:R11:B16:R16,{"january(H4:X4:H9:X9:H14:X14)=1","Deposit","Cash"},B3:R3:B8:R8:B13:R13))
