Forum Discussion
Solved
Simple Excel sum formula showing error
I have a simple Excel spreadsheet (summary) with multiple columns (approx. 48) summarizing nine rows of data linked from an adjoining sheet (upload). The columns total down with no problem. However, ...
my guess is there is a hidden column that has an error in it.
maybe try:=TRIM(TEXTJOIN(",",1,IF(ISERROR(B42:AT42),ADDRESS(ROW(B42:AT42),COLUMN(B42:AT42)),"")))
and see if it tells you where
my guess is there is a hidden column that has an error in it.
maybe try:
=TRIM(TEXTJOIN(",",1,IF(ISERROR(B42:AT42),ADDRESS(ROW(B42:AT42),COLUMN(B42:AT42)),"")))
and see if it tells you where
Thanks so much! There was a hidden column with a #REF! error in it. Don't remember hiding the column and no idea where the error came from. Thanks for helping me find it.
