I used this formaular IF(B$3="Actual",SUMIFS($B14:$M14,$B$3:$M$3,"Actual")) to arrive at £98,000 but I want to tweak it for the Forecast as well. so I can have a total for actual and forecast separately. Thanks
I used this formaular IF(B$3="Actual",SUMIFS($B14:$M14,$B$3:$M$3,"Actual")) to arrive at £98,000 but I want to tweak it for the Forecast as well. so I can have a total for actual and forecast separately. Thanks
Last edited by Johnyam54; 07-05-2024 at 07:56 AM. Reason: Please attached file
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks