Sep 21 2022 07:46 PM
I have a formula that I am using, but it is not calculating correctly. i was informed to try using the F9 function short-key.
After checking with Microsoft support they informed me that I need to have controller addins to make F9 work. Can someone please check and help me with that addins to make it work? I need it for my work. Please contact me ASAP.
Here is the formula that we are using.
=SUMIF(W9:W131,AM10&M4,AA9:AA131)
Sep 21 2022 11:53 PM
there is no additional add-in necessary to use F9 key.
The F9 key just forces a recalculation in case you have set the calculation mode to manual. Otherwise, the formulas would recalculate automatically anyway. So hitting F9 is just to make sure the worksheet gets recalculated. No add-in's necessary.
If the formula does not give the desired result, then there is probably an issue with the criteria in cell AM10 and M4.
Sep 22 2022 06:03 AM