Hi All,

I'm trying to produce a total of three non-adjacent cells, all cells are numbers, no negatives BUT for a linked graph to display I have to use NA() option.

This creates an error if I try and total the three cells (=B10+B21+B32) so (after much web searching) I came across the AGGREGATE formula.

The formula is (I thought) simply:
=AGGREGATE( 9,6, B10,B21,B32)

where 9 = SUM
6 = Ignore all errors
B10 = #N/A
B21 = #N/A
B32 = 1

I expected the output to be 1 but instead I get #NAME?

Can anyone help, please?