Average If Problem

Giganews Newsgroups
Subject: Average If Problem
Posted by:  Kris Taylor (pacman_…@hotmail.com)
Date: 12 May 2004

Hi all,

Here is my current dilemna.  I have a bunch of dates in column A (in
02/31/2004 format) and random numbers in column B (Some cells contain
N/A or contain nothing).

What I need is a formula that will average the numbers in B for each
associated month for the year 2004.

Please show a forumala that I could use to accomplish this for January
and then something harder like February (Harder because you will have
to filter out smaller months like Jan and the larger months)

If anyone could help, it would be greatly appreciated.  I've already
tried numerous SUMPRODUCTS and AverageIfs and none seem to work...

Thanks in advance,

Kris Taylor

Replies