I like to use formatted dates as column headers. But when I sum the column and ignore the column header that is in date format, the sum formula gives me a warning flag.
Is there a way to stop this?
I like to use formatted dates as column headers. But when I sum the column and ignore the column header that is in date format, the sum formula gives me a warning flag.
Is there a way to stop this?
No idea what you are trying to describe. What column(s)? What formula? What warning flag?
Post a sample workbook. See the yellow banner at the top of the page.
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
If you mean you have dates like 2 Mar 2021 in, say row 3, nothing in rows 1 and 2, and numeric values in row 4 down, and you're using formulas like =SUM(X:X) or more likely =SUM(X:X)-X3, then you're intentionally doing something suboptimal.
You could suppress error indicators generally, but that's a bad idea. You could live with them too, accepting that what you're doing has the unavoidable consequence of displaying such indicators. Or you could avoid such constructs and use formulas like =SUM(X4:X1000), which would be better in all ways except convenience and would certainly remove the error indicators unless there were something amiss from row 4 down.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks