Formula format in excel that returns an "error" if there is a blan

K

Ken Proj mgr

I am adding monthly data and I need to get 12 months worth. Is there a
formula that will result in an "error" if I have a zero in one of the cells?
Can this be conditionally formatted to pick up the missing data?

Column "A" has data that is input. Column "B" needs to sum 12 cells from
Column "A", example =sum(a1:a12). How to format when column "A" has yet to
get data.
 
G

Gazeta

U¿ytkownik "Ken Proj mgr said:
I am adding monthly data and I need to get 12 months worth. Is there a
formula that will result in an "error" if I have a zero in one of the cells?
Can this be conditionally formatted to pick up the missing data?

Column "A" has data that is input. Column "B" needs to sum 12 cells from
Column "A", example =sum(a1:a12). How to format when column "A" has yet to
get data.
Click to expand...

try to combine if and min(your range)
mcg
 
C

CLR

Maybe..........

=IF(COUNTIF(A1:A12,">0")=12,SUM(A1:A12),"ERROR")

Vaya con Dios,
Chuck, CABGx3
 
Top