Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula format in excel that returns an "error" if there is a blan
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula format in excel that returns an "error" if there is a blan
U¿ytkownik "Ken Proj mgr" napisa³ w wiadomo¶ci ... 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. try to combine if and min(your range) mcg |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula format in excel that returns an "error" if there is a blan
Maybe..........
=IF(COUNTIF(A1:A12,"0")=12,SUM(A1:A12),"ERROR") Vaya con Dios, Chuck, CABGx3 "Ken Proj mgr" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula format in excel that returns an "error" if there is a
MCG,
Could you please give an example. "Gazeta" wrote: U¿ytkownik "Ken Proj mgr" napisa³ w wiadomo¶ci ... 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. try to combine if and min(your range) mcg |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula format in excel that returns an "error" if there is a
Chuck,
IT WORKS....... YOU SIR ARE THE MAN!!! THANK YOU. KEN "CLR" wrote: Maybe.......... =IF(COUNTIF(A1:A12,"0")=12,SUM(A1:A12),"ERROR") Vaya con Dios, Chuck, CABGx3 "Ken Proj mgr" wrote: 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula format in excel that returns an "error" if there is a
Happy to help.......thanks for the feedback.
Vaya con Dios, Chuck, CABGx3 "Ken Proj mgr" wrote: Chuck, IT WORKS....... YOU SIR ARE THE MAN!!! THANK YOU. KEN "CLR" wrote: Maybe.......... =IF(COUNTIF(A1:A12,"0")=12,SUM(A1:A12),"ERROR") Vaya con Dios, Chuck, CABGx3 "Ken Proj mgr" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Excel 4 formula to Excel 2003 format | Excel Worksheet Functions | |||
excel array formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Can Excel represent formula in textural format with values substi. | Excel Worksheet Functions | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions |