smistretta,

You don't really give enough information for, (me to give), a real answer
but if the "Projects" column is column G then:

=IF(AND(COUNTA(A5:F5)=6,ISNUMBER(G5)),SUM(F5:G5),I F(COUNTA(A5:F5)=6,"Fill in
'Projects' Column",""))

Will remain with no display until columns A:F have (any) data in them then
it will display "Fill in 'Projetcs' Column"

When the Projects column is filled in as well,(but not if A:F are not also
filled in), then the SUM will be returned.

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"smistretta" wrote in message
...
Our NPO is creating a reimbursement chart in Excel. We're trying to make
it
so that if employees do not fill in one particular column entitled
"Projects," they will get an error or will be unable to have a final sum
filled in.

Is there any way I can make this particular column required so that if it
is
not filled in, the chart will not complete properly?

Thank you in advance for any advice or help--I'm a bit of a novice to
this!