Sum Up the last 7 (n) numbers in a column ignoring the error

[Arnefer1206]

Good Day!

Hope anyone could assist me

I have this data in column A

A1 - 5
A2 - 10
A3 -15
A4 - 9
A5 - 5
A6 - 7
A7 - 20
A8 - #N/A
A9 - 14
A10 - 4

I want to get the sum of the last 7 cell value containing numbers and ignoring the cell with error (#N/A)

The result must be 74 - adding up (A10, A9, A7, A5, A4, A3)

 

[Arnefer1206]

=IFERROR(AGGREGATE(9,6,INDEX(A:A,LARGE(IF(ISNUMBER(A1:A10),ROW(A1:A10)),7)):A10),"<7 numbers") array-entered

Haven't checked exhaustively, but looks as if it may be more robust, e.g. try #N/A in A2 instead of A8.

Sir Stephen

Could your spare me more

Its almost same with my sample data

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.