I need to add a column of numbers but exclude one row if another row contains data.
E elsmith9035768 Member Feb 19, 2017 #1 I need to add a column of numbers but exclude one row if another row contains data. Attachments Add column excluding one row, if needed..xlsx 9.3 KB · Views: 7
B bosco_yip Excel Ninja Feb 20, 2017 #2 D4, copy across : =SUM(D5:D7)+IF((D5="")+(D5=0),D8,0) Regards Bosco