I am building an attendance database using columns A-N. Very standard
Name(A), 12 months(B-M), and a Total(N) columns. I am using a COUNTIF formula
to count X's marked for a month attended.

What I want to do is everytime a new name is added to the sheet(ie A5) the
corresponding total columns(N5) formula =COUNTIF(B5:M5,"X") will appear for
that cell(N5) and so on. Can this be done?

Conditional Formatting only formats existing data.

It cannot create formulas for you.

You can hide the formulas' results until data is entered.

=IF(A5="","",COUNTIF(B5:M5,"X"))

Drag/copy down column N as far as you wish.

Nothing will show until you have entered data in column A

OR.............you could use event code to copy the formula down each time
you enter a new name in Column A

But why scare users with a macro warning when the above could be a solution.


Gord Dibben MS Excel MVP


On Tue, 17 Mar 2009 12:13:01 -0700, Russ
wrote:

I am building an attendance database using columns A-N. Very standard
Name(A), 12 months(B-M), and a Total(N) columns. I am using a COUNTIF formula
to count X's marked for a month attended.

What I want to do is everytime a new name is added to the sheet(ie A5) the
corresponding total columns(N5) formula =COUNTIF(B5:M5,"X") will appear for
that cell(N5) and so on. Can this be done?