Hi

How do I go about summing all the cells in a row based on their number format.

I will only have either 0.00% or #,##0.00 and need to sum the non pct
formatted cells.

Thanks in advance.

Regards