Posted to microsoft.public.excel.worksheet.functions

Nestor[_2_] Nestor[_2_] is offline

external usenet poster

Posts: 3

countif when the criteria is a formula

On col A1toA100 have number,from col B10 have the averages of last 10 numbers
AVERAGE(A1:A10).I cannot get a result on C10 from COUNTIF(A1:A10,"B10").
Can anyone help?
Nestor

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
How do I put a date range in the criteria of a countif formula?	hlpmelrn	Excel Discussion (Misc queries)	3	November 23rd 06 03:12 AM
2 criteria for a COUNTIF formula?	aaronwexler	New Users to Excel	6	September 3rd 05 10:13 AM
Countif Formula with changing criteria	Stephen	Excel Discussion (Misc queries)	2	May 2nd 05 07:24 AM
Countif formula with multiple criteria ie >30 and <60?	Dali	Excel Worksheet Functions	2	January 7th 05 04:49 PM
use a date range as criteria in a countif formula	mbparks	Excel Worksheet Functions	3	January 2nd 05 11:06 PM

All times are GMT +1. The time now is 07:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us