Posted to microsoft.public.excel.misc

v1rt8

external usenet poster

Posts: 34

averageif with 2 other criteria

Need some help with an averageif calc.
setup is as follows:
q3:q1357 contains ages
r3:r1357 contains text (active), (MGT), (others)

so averageif q3:q1357 active and mgt in 43:r1357
so averageif

looked at other questions in here and cannot find anything close
thanks in advance

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
AVERAGEIF	T. Valko	Excel Worksheet Functions	9	July 15th 09 07:01 PM
Help with Averageif Formula (don't think I should use Averageif)	MUmfleet	Excel Discussion (Misc queries)	5	April 9th 09 04:53 PM
AVERAGEIF	Tung Nguyen	Excel Worksheet Functions	3	April 4th 09 01:29 AM
AverageIF with cell refenrence as criteria is not working	Bart Geerling	Excel Discussion (Misc queries)	4	November 22nd 07 08:36 PM
averageif	name	Excel Worksheet Functions	1	May 4th 06 05:27 PM

All times are GMT +1. The time now is 10:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us