IF function

**usaf_kirby** · 02-15-2011, 04:34 PM

I was wondering if I could help with the =IF function

We have cells with a value of 100%, but not ever cell in a column. If the cell is 100%, then I want it to equal 1, and if not, then equal 0 (which is the easy part), but how do I add each of these functions through a series of cells to get a total whole number at the bottom. SO if we had 47 100%'s, then it would say 47?

**NBVC** · 02-15-2011, 04:37 PM

To count with condition, you can use COUNTIF...

e.g

=COUNTIF(A1:A100,100%)

where A1:A100 is the whole range.

**usaf_kirby** · 03-04-2011, 11:22 AM

Thanks, that worked!

Now, I need to know how to set up the worksheet so that It shows what page will show when you print (like when it is separated by the blue lines and says "PAGE 1" in big letters).

I also need to know if it is possible to have a Cell with a date in it that will automatically change to today's date when I change data in a range of cells. I.E A1 will change to todays dat if I change an data from A2:M2? Is this possible?

Also, say I need to know how many cells are greater than or equal to 85%?