Question:

I have and Excel Spreadsheet with many columns. Columns F J N R V Z AD AH AL AP AT AX all have or will have totals in them. Each columns represents one month.

I want to create a formula that averages all these columns but only if they are populated.

For example F is for November and J is for December. These two columns will be populated because I started this sheet last month. But all the others will not be so for this month a want and average for Nov and Dec next month I will want an average for Nov, Dec and Jan. I am just not sure how to write this.

Thanks!!

Solution:

And for the second question?

if they all have a Common Heading use this.

=SUMPRODUCT($C$6:$N$6*($C$1:$N$1=”Heading”)*($C$6:$N$6<>”0″))/SUMPRODUCT((1)*($C$1:$N$1=”Heading”)*($C$6:$N$6<>0))
Change $C$1:$N$1 to the Heading Location
Change $C$6:$N$6 to your Total Range ($F$100:$AX$100)

See the attached File for the example

EE-Test.xls (16 KB) (File Type Details)
SUMPRODUCT Test