Posted to microsoft.public.excel.misc

Per Jessen Per Jessen is offline

external usenet poster

Posts: 1,533

CountIf formula

Hi

Just enlarge the range to as many rows as you think you will need:

=COUNTIF(P2:P1000,"x")

Regards,
Per

"Verne" skrev i meddelelsen
...
I am using a count if formula =COUNTIF(P2:P25,"x") - everytime I add a new
row, that row is not included in the formula. What can I do so it is
included. Right now, I have to add the row to the formula manaually. Thank
you for your help.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF formula	Maxx	Excel Worksheet Functions	2	June 19th 09 05:24 AM
CountIf formula results in the formula itself being displayed.	NewKid	Excel Worksheet Functions	9	December 21st 05 11:10 PM
CountIf formula help	Lucien	Excel Discussion (Misc queries)	2	September 29th 05 08:14 PM
countif formula	Todd Nelson	Excel Discussion (Misc queries)	1	September 21st 05 11:27 PM
Countif formula and then some...	Julie	Excel Worksheet Functions	6	July 27th 05 08:13 PM

All times are GMT +1. The time now is 03:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us