Keep getting this error message #Value!. Was working before and cell above has the same formula and works fine.
Mod Edit: I have updated your thread title - please look at the forum rules ASAP.
Keep getting this error message #Value!. Was working before and cell above has the same formula and works fine.
Mod Edit: I have updated your thread title - please look at the forum rules ASAP.
Last edited by AliGW; 02-08-2022 at 07:44 AM. Reason: Title changed - please think more carefully about your thread titles in future!
In O9 copied down:
=SUM(L9:N9)
SUM will ignore empty cells.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Click in cell M12 and clear the contents. It has a space character in it.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
@Ali: the OP is not summing three cells; N9 is subtracted.
Thank you so much, never thought of doing it that way. Much appreciated
Ah! So (s)he is - oops! Rushing to get out of the door - sorry!
Doing what, what way. The formula Ali provided is not appropriate.Thank you so much, never thought of doing it that way. Much appreciated
See post #3 and fix the actual problem.
Mooseman1960 = CraigSo (s)he is - oops
Only if you already know the associated name, Trevor ...
No, it's in the workbook properties
Well, as I said, I was in a rush to get out of the door. Snooping around in to personal properties in a workbook is not something I tend to do unless I have good reason to!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks