Forum Discussion
#VALUE! Error
I want to simply add 5 cells together in cell M25. I have never gotten an error on a formula that is so simple! I am getting error message #VALUE! when I try to enter either of the following formul...
This is what I would do. It is not necessarily what I might recommend the OP should do!
= SUM(TAKE(WRAPCOLS(numbers, 2), 1))It splits the numbers into twos and discards the second row before summing.