Counting certain cells that are greater than a value

Hi All

I need to be able to sum if certain cells are less than 35, my cells are


A A B A B TOTAL
20 39 12 28 34 ????


So in the total i want to sum if the A's are less than 35, my answer would be 48

I have tried

Formula:

Please Login or Register  to view this content.

And various others but cant seem to get it to sum those particular cells, its easy enough to do one cell

Formula:

Please Login or Register  to view this content.

then it returns 20, but i cant get them to go together

If i do

Formula:

Please Login or Register  to view this content.

then i get a return of 60, but this then includes the cell C2 which is a B product

Any suggestions? i thought maybe the AND function would be helpful but dont have much knowledge on AND

=SUMIF(A1:E1,"<35")

But your result should be 94. Not 48

20 39 12 28 34

Then try

=SUMPRODUCT((A1:E1="a")*(A2:E2<35)*(A2:E2))

Edit:OR

=SUMIFS(A2:E2,A2:E2,"<35",A1:E1,"a")