Wynn

Posts: n/a

Averaging COUNTIF

I want to average numbers in column B, only in column A has a specific term
(in other words, an average of all rates in column B where column A contains
the word "DG").

I am figure I need to use COUNTIF, OFFSET, and AVERAGE functions, but I am
having trouble putting them together. Thanks!

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
Subtotal And Countif	Sheryl	Excel Discussion (Misc queries)	4	December 9th 04 07:18 PM
Countif	bjg	Excel Worksheet Functions	11	November 27th 04 03:32 PM
Countif - Countif	maswinney	Excel Worksheet Functions	3	November 15th 04 11:06 PM
Countif ???	terryv	Excel Worksheet Functions	2	November 8th 04 09:03 AM
countif, again	Liz G	Excel Worksheet Functions	2	November 1st 04 11:20 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us