Hi!
In the excel sheet, i want to change dates in the dropdown menu (red), and then the yellow should change based on a summary of the months that are involved. I hope its understandable.
Thanks! You are the best in this forum..
Hi!
In the excel sheet, i want to change dates in the dropdown menu (red), and then the yellow should change based on a summary of the months that are involved. I hope its understandable.
Thanks! You are the best in this forum..
C17=SUMIFS($B11:$M11,$B$9:$M$9,">="&$C$16,$B$9:$M$9,"<="&$D$16)
C18=SUMIFS($B12:$M12,$B$9:$M$9,">="&$C$16,$B$9:$M$9,"<="&$D$16)
Try the above formula
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
For the income calculation: =SUMPRODUCT(--($B$9:$M$9>=C16)*B11:M11)-SUMPRODUCT(--(B9:M9>D16)*B11:M11)
For the profit calculation: =SUMPRODUCT(--($B$9:$M$9>=C16)*B12:M12)-SUMPRODUCT(--(B9:M9>D16)*B12:M12)
Excel 365 user. To unblock a downloaded macro-enabled workbook, go to your "Downloads" folder > right click on the workbook name > click 'Properties' > check the 'Unblock' checkbox. You can now open the workbook.
Thanks! I think this will work. Can someone explain whats going on in the formula?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks