R. VENKATARAMAN

[Jaladino]

when summing up in H21-- A21*G21 and there is no entry for G that row I'm
getting a #Value! error, can I change somethink so its blank rather than
Value (which will interefere with the total)

 

[Trevor Shuttleworth]

=IF(G21="",0,A21*G21)

Regards

Trevor

 

[Max]

Just change the value_if_true in the error trap formula
to return a zero: 0 instead of ""
i.e. try instead in C21:

=IF(ISNA(MATCH($B21,$J$21:$J$37,0)),0,VLOOKUP($B21,$J$21:$L$37,COLUMNS($A$1:
A1)+1,FALSE))

or use SUM(... ), e.g.: =SUM(A1:A2) instead of : =A1+A2
(SUM will ignore text)