In response to Sandy's post:

Thank you for your help. I'm not sure what information you need, so I'll
include what I can:

Projects Column in column J
"Totals" are in Row 22 and the Grand Total cell is L22
First row of data entry strings from B8 to I8
Data rows run from row 8 to row 21

I tried to use your suggestion in my Excel table but it keeps telling me it
is a circular formula. Any thoughts or ideas?

Thank you again!

"Sandy Mann" wrote:

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!