I want ot enter a formula in cell A20 which should be the sumproduct of range
A1 to A19 & of coloumn B1 to B19 but to exclude some cells from both
coloumns, conditionality being if there are no figures in any of the cell
(cell value being 0). Thus if cell A5=0, to ignore both cell A5 & B5.
pL help.
Thanks in anticipation