Countif percentage average formula

[snidaere]

Attached is an example. I need to get a true average of colum F with only the results from the COUNTIF in column E. The formula counts row 3 as zero when I want it to stay blank, so I can AutoSum average the column. This is on a 3000 row spreadsheet so I need it to be as automatic as possible THANKS!

[sandy666]

try:

Please Login or Register  to view this content.

[José Augusto]

Hi
Try this

Please Login or Register  to view this content.

Regards