Count the last 8 cells containing (desired value / reference ex. "Increased") and ignoring the cells containing error (#N/A)

[Arnefer1206]

Expert hope your could assist me again. Last one for today!

Many thanks in advance

A1 - Increased
A2 - Increased
A3 - Decreased
A4 - Decreased
A5 - Maintain
A6 - Increased
A7 - Increased
A8 - Increased
A9 - #N/A
A10 - #N/A
A11 - #N/A
A12 - Decreased
A13 - Decreased
A14 - #N/A
A15 - #N/A

I want to get the count of the last 8 cell value containing "Increased" or "Decreased" and ignoring the cell with error (#N/A)

The result must be

"Increased" - 3
"Decreased" - 4

The 8 cells to be counted are {A13, A12, A8, A7, A6, A5, A4, and A3} , ignoring the the cells {A15, A14, A11, A10 and A9} because it contains error (#N/A)

 

[Peter_SSs]

Duplicate to Count the last 8 cells value containing (reference. ex. "Increased") and Ignoring the the Cell Value with Error (#N/A)

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.