Hi,

I have the following formula:

=IF(ISERROR(COUNTIF(StatusCheck, "Snag Item")/COUNTIF(ElementCount,"Main
Contractor - Builderswork")),0,COUNTIF(StatusCheck, "Snag
Item")/COUNTIF(ElementCount,"Main Contractor - Builderswork"))

Originally I had some problems getting ISERROR to work properly - but this
is sorted now.

The formula is supposed to count the number of times a snagging item is
added into the spreadsheet (each snagging item has its own row) that is
assigned a status of "Snag Item" and an Element of "Main -Contractor -
Builderswork". The formula works fine for one item - but if two or more are
added the formula returns 1.

Any ideas why this is not working.?

Cheers,

Phil