Forum Discussion
array formula
I have an array =sum formula that works on one excel spreadsheet but doesn't on another. What am I doing wrong where it doesn't work on the second spreadsheet?
"doesn't work" is not a complete description of what DOES happen. What are the similarities and differences between the two sheets? What does happen in connection with this formula (which, by the way, probably IS working; just not producing the value or result you expect). Do you get an error message? Do you get a result that's incorrect? Does the formula refer to other cells, other ranges, cells or ranges that differ from one sheet to the next?
Etc.
Etc.
Thank you for your time. I finally created a new excel spreadsheet, copied and pasted the information with the array formula and everything worked.