Help with sumation formulas

[kparadise]

I am trying to write a formula to sum a column of data then divide by the count to create an average value.

Where I am getting held up is that some of the data is numbers, some is text and numbers (ie BRL<5). What I need to do is to sum the numbers by themselves, and the ones with text seperate, because the ones with text get halved. For example BRL<5 would be treated as 2.5 for average calculation purposes. It still needs to read BRL<5 for the printed table though.

Thanks for the help!

[mrice]

This user defined function will help

Please Login or Register  to view this content.

Paste this into a new module in the VBA editor (Alt F11).

You will then have a new function called AverageSpecial in the user defined section of the function wizard.