If function with Sumifs

Hi team,

Could someone please assist to help me pull through the actual or forecast for specific month on my expected result-so at any time when the actual or forecast changes by moving the cell from the source data my result tab will update.
On the if statement formular my value if criteria should only pick the sum of forecast for specific month if it is not actual.

Thanks for all your support.
John

in B4

Formula:

Please Login or Register  to view this content.

Copy across and down

No need for IF statement

Administrative Note:

Is your forum profile showing the oldest Excel PRODUCT that you need this to work for?

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.

Please respond to post #3.

See attached

HI John,

Thanks for coming back to me.
Could you please amend/update my formular --=IF(B$3="Actual",SUMIFS($B14:$M14,$B$3:$M$3,"Actual"))

I want to sum the actual and forecast separately.

Actual spend todate 98000
Forecast remaining to spend FALSE

Thanks

Actual spend todate 98000

No idea how you get the above

nor do I understand your requirement re the formula.

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

It would appear ( to me) you do not understand the SUMIFs statement.

The formula I provided does exactly what you stated in your expected results

None the wiser so I'll leave this.

Look at the file in post#8.

You have ignored me TWICE in this thread.

Please respond to post #3 now.

Then, if that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

You have still failed to respond to post #3 - I asked a question and need an answer, please, before you post here again. Thanks.

Thanks very much AliG

It's AliGW.