software

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

Column quot;Aquot; has data that is input. Column quot;Bquot; needs to sum 12 cells from
Column quot;Aquot;, example =sum(a1:a12). How to format when column quot;Aquot; has yet to
get data.


U¿ytkownik quot;Ken Proj mgrquot; gt; napisa³ w
wiadomo¶ci ...
gt; I am adding monthly data and I need to get 12 months worth. Is there a
gt; formula that will result in an quot;errorquot; if I have a zero in one of the
cells?
gt; Can this be conditionally formatted to pick up the missing data?
gt;
gt; Column quot;Aquot; has data that is input. Column quot;Bquot; needs to sum 12 cells from
gt; Column quot;Aquot;, example =sum(a1:a12). How to format when column quot;Aquot; has yet to
gt; get data.

try to combine if and min(your range)
mcg
Maybe..........

=IF(COUNTIF(A1:A12,quot;gt;0quot;)=12,SUM(A1:A12),quot;ERRORquot;)

Vaya con Dios,
Chuck, CABGx3

quot;Ken Proj mgrquot; wrote:

gt; I am adding monthly data and I need to get 12 months worth. Is there a
gt; formula that will result in an quot;errorquot; if I have a zero in one of the cells?
gt; Can this be conditionally formatted to pick up the missing data?
gt;
gt; Column quot;Aquot; has data that is input. Column quot;Bquot; needs to sum 12 cells from
gt; Column quot;Aquot;, example =sum(a1:a12). How to format when column quot;Aquot; has yet to
gt; get data.

MCG,
Could you please give an example.

quot;Gazetaquot; wrote:

gt;
gt; U¿ytkownik quot;Ken Proj mgrquot; gt; napisa³ w
gt; wiadomo¶ci ...
gt; gt; I am adding monthly data and I need to get 12 months worth. Is there a
gt; gt; formula that will result in an quot;errorquot; if I have a zero in one of the
gt; cells?
gt; gt; Can this be conditionally formatted to pick up the missing data?
gt; gt;
gt; gt; Column quot;Aquot; has data that is input. Column quot;Bquot; needs to sum 12 cells from
gt; gt; Column quot;Aquot;, example =sum(a1:a12). How to format when column quot;Aquot; has yet to
gt; gt; get data.
gt;
gt; try to combine if and min(your range)
gt; mcg
gt;
gt;
gt;

Chuck,
IT WORKS....... YOU SIR ARE THE MAN!!!

THANK YOU.

KEN

quot;CLRquot; wrote:

gt; Maybe..........
gt;
gt; =IF(COUNTIF(A1:A12,quot;gt;0quot;)=12,SUM(A1:A12),quot;ERRORquot;)
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt;
gt; quot;Ken Proj mgrquot; wrote:
gt;
gt; gt; I am adding monthly data and I need to get 12 months worth. Is there a
gt; gt; formula that will result in an quot;errorquot; if I have a zero in one of the cells?
gt; gt; Can this be conditionally formatted to pick up the missing data?
gt; gt;
gt; gt; Column quot;Aquot; has data that is input. Column quot;Bquot; needs to sum 12 cells from
gt; gt; Column quot;Aquot;, example =sum(a1:a12). How to format when column quot;Aquot; has yet to
gt; gt; get data.

Happy to help.......thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3
quot;Ken Proj mgrquot; wrote:

gt; Chuck,
gt; IT WORKS....... YOU SIR ARE THE MAN!!!
gt;
gt; THANK YOU.
gt;
gt; KEN
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; Maybe..........
gt; gt;
gt; gt; =IF(COUNTIF(A1:A12,quot;gt;0quot;)=12,SUM(A1:A12),quot;ERRORquot;)
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Ken Proj mgrquot; wrote:
gt; gt;
gt; gt; gt; I am adding monthly data and I need to get 12 months worth. Is there a
gt; gt; gt; formula that will result in an quot;errorquot; if I have a zero in one of the cells?
gt; gt; gt; Can this be conditionally formatted to pick up the missing data?
gt; gt; gt;
gt; gt; gt; Column quot;Aquot; has data that is input. Column quot;Bquot; needs to sum 12 cells from
gt; gt; gt; Column quot;Aquot;, example =sum(a1:a12). How to format when column quot;Aquot; has yet to
gt; gt; gt; get data.