Forum Discussion
alanaw735
Oct 31, 2024Copper Contributor
Error in my formula
I have a shared excel document but for some reason only on mine this specific formal isn't working - I have tried everything that google has told me. the formula is to help track deliveries and ...
HansVogelaar
Oct 31, 2024MVP
There are several possible causes:
This formula uses R1C1 notation. If you use A1 notation, the formula will not be recognized.
To switch, select File > Options > Formulas and tick the check box R1C1 reference style.
If you use comma as decimal separator, replace the commas in the formula with semicolons ;
The MINIFS function was introduced in Excel 2019. If you have an older version, it will not be recognized.
alanaw735
Oct 31, 2024Copper Contributor
Thank you - it is now working 🙂