I need help getting an average of column data. I only want to average values which are greater than zero (or not blank), based on column header data, and row criteria. Here is an example of what I need.
WEEK1 WEEK2 WEEK3 WEEK4
ITEMA 50 0 30 50
ITEMB 100 125 125 50
ITEMC 0 0 40 30
So if I wanted average data for ITEMA, only for weeks 2-4, and only if greater than zero, the result would be 40.
Thanks so much for anyone who can help.
devious66
WEEK1 WEEK2 WEEK3 WEEK4
ITEMA 50 0 30 50
ITEMB 100 125 125 50
ITEMC 0 0 40 30
So if I wanted average data for ITEMA, only for weeks 2-4, and only if greater than zero, the result would be 40.
Thanks so much for anyone who can help.
devious66