Hello! I'm a very frustrated beginning excel user and could use your help!
I've read the posts regarding using SumIF to ignore error cells when adding a group of cells, but when I try to use the formula I get an error. I think it's because I'm trying to add cells that are not continuous.
Here's what I tried:
=SUM(Q5,U5, X5, AF5, AK5, AN5, AR5, AV5, BA5, BD5, BH5, BL5, BS5, BX5, CA5,<>#N/A)
How can I fix this to add my cells, but ignore those that have errors?
Thanks!!
Michelle
I've read the posts regarding using SumIF to ignore error cells when adding a group of cells, but when I try to use the formula I get an error. I think it's because I'm trying to add cells that are not continuous.
Here's what I tried:
=SUM(Q5,U5, X5, AF5, AK5, AN5, AR5, AV5, BA5, BD5, BH5, BL5, BS5, BX5, CA5,<>#N/A)
How can I fix this to add my cells, but ignore those that have errors?

Thanks!!
Michelle