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?
Bookmarks