Bill Martin -- (Remove NOSPAM from address)

Posts: n/a

davidad wrote:
Is anybody out there aware of an "AVERAGEIF" function ?.
I'm new to programming and have failed miserably trying to
write it. Any help would be great.

--------------------------

Peo gave you the "right" solution. Here's the more intuitive one:

[ ] = SumIf(A1:A5,"0")/CountIf(A1:A5,"0")

Obviously you'll need to substitute your own arguments into it, but it
should give you the idea.

Bill

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
Averaging function	Sarah	Excel Discussion (Misc queries)	0	January 18th 05 04:09 PM
Accessing a Function	Bill Martin -- (Remove NOSPAM from address)	Excel Discussion (Misc queries)	4	January 1st 05 05:46 AM
Function in XL or in VBA for XL that pulls numeric digits from a t	Nate Oliver	Excel Discussion (Misc queries)	0	December 14th 04 04:57 PM
Excel function help facilities	RPS	Excel Discussion (Misc queries)	1	December 8th 04 02:36 AM
I cant use englisch function names in a swedich version of excel	PE	Excel Discussion (Misc queries)	2	December 7th 04 01:00 AM

All times are GMT +1. The time now is 04:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us