is there a formula for this (when working with 2 tabs)

**wonderingwoman** · 03-23-2012, 08:52 AM

I have an excel document with 2 tabs..

Is it possible for a value in a box (C4) on tab 2 to be increased by 1 if any box in the corresponding column in tab 1 (C) is filled (note, they are filled with dates).

For example, the column on tab 1 is a list of enrollment dates..
and there is a table on tab 2 that sums up tab 1..
Like
total football participants = [box C4 that i am trying to see if excel can do automatically]

I hope that i'v explained it ok?
And hope someone can help.

**royUK** · 03-23-2012, 08:52 AM

Can you read the Forum Rules then amend your thread title

**royUK** · 03-23-2012, 09:02 AM

Every question here is about Excel How does that title comply with Rule # 1

**Fotis1991** · 03-23-2012, 09:06 AM

..Also(if i understand well), rule 4, of the forum, says:

4. Don't Private Message or email questions to moderators or other members. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.

**wonderingwoman** · 03-23-2012, 11:07 AM

Originally Posted by Fotis1991

..Don't Private Message or email questions to moderators or other members.

How have I possibly done that?

I just wanted a little advice, I didn't think everyone would have a go at me for asking for help.

**arlu1201** · 03-23-2012, 11:14 AM

Do you have a sample file that you can upload?

**wonderingwoman** · 03-23-2012, 11:30 AM

here is an example of the problem (obviously limited due to confidentiality)

it would be much appreciated if you would take a look and if you or anyone else knows if it is possible to do what i hoped to do

kind regards