Cant manage to build a formula to sum up values in many rows, using a criteria.

[AMIRD]

Hello.

I have a table, in which I have a row of numeric value, and underneath it a row of text, and then again more pairs of rows as such, underneath.
I'm looking for a formula to sum all cells that have underneath them the letter 'a' (just as an example). (in the small example below, the answer will be 85).
I can do it only for one pair of rows using SUMIF, but I can't seem to find a way to do it for a big table, with many pairs of rows such as these.
I'd be very happy if anyone can help.
THANK you!

54	8	65	54	32	2
d	a	r	f	d	a
29	18	17	13	32	1
d	e	a	a	f	d
20	15	16	18	13	11
a	f	v	b	e	w
11	31	10	13	15	11
d	e	a	w	a	s

<colgroup><col width="72" span="6" style="width:54pt"> </colgroup><tbody>
</tbody>

 

[Aladin Akyurek]

Try:

=SUMIFS($A$1:$F$7,$A$2:$F$8,H1)

where H1 houses a value like 'a'.

 

[AMIRD]

Try:

=SUMIFS($A$1:$F$7,$A$2:$F$8,H1)

where H1 houses a value like 'a'.

ALADIN AKYUREK, THANK YOU SO MUCH!! worked perfectally, and I also learned a new principle in excel. Thank you!

 

[Aladin Akyurek]

ALADIN AKYUREK, THANK YOU SO MUCH!! worked perfectally, and I also learned a new principle in excel. Thank you!

You are welcome.