Maybe you mean something like this in say, B2, copied down:
=if(A2="","",SUMIF(€¦))
The front IF check on A2:
=if(A2="","", ...
will avert further evaluation of the SUMIF
should A2 be either blank or contain a zero length null string: ""
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"eric" wrote:
what fomula would I use to add criteria in one cell only when the cell next
to it has data entered? Basically, I don't want the first cell to be part of
a formula until it has relevency. The cells are not part of a continuous
range either(i.e. they might be a4, a14,a24,a34 etc.)