I need some help to count the number of red cells in a row (or the number of'<' symbols). When I use a countif function it returns zero so there must another function suitable and I am having a mental block. Anyone able to help please? I have attached an image of the spreadsheet that I am trying to count. I don't have the developer link so I am unable to use VB at this time.
Many thanks,
Ann