Excel "formula omits adjacent cells"

Hello,

On my formula I get this "formula omits adjacent cells", but I do not need to include adjacent cells and the sum is correct. Am I doing something wrong or is there a proper way to create a formula that does not include all the cells in a row? Thank you?

If you don't intend to include adjacent cells in the sum, you can ignore the warning.

If you wish, you can disable the error alerts: https://support.office.com/en-us/article/hide-error-values-and-error-indicators-761401bc-25de-4673-862a-b6f33a7f563f

---
Best wishes, HansV
https://www.eileenslounge.com

7 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 13, 2025 Views 2,555 Applies to: