Countif using certain criteria to identify an average

[bigmonkey712]

Hi,

I am doing a price comparison and want to add a field for average price. However not all fields are populated on every row so cannot simply add up and divide by total.

Therefore I am trying to do a countif to show only populated cells. I cannot use simply countif >0 as I have another cell with a price in and I only want to count cells lower.

To illustrate:
I have column A with prices.
I want to count how many from column B to N are less than column b but greater than 0 (to eliminate blanks).
This will allow me to do an average by adding A-N and divide by the result of the countif as the number to divide by varies depending on how many cells in that row are populated.

I appreciate any help on this.

Many Thanks

Stewart

 

[gaz_chops]

Try countifs using ">"&B and ">0"