asked on

i need a formula for sum if

hi all
im attaching a capture screen that what i need
as example

i want to sum all values if the cell above say yes,
in the example i need to sum 9 and 5 but i need do it in all range because is variable
is any way to achive that
regards
cap-pan.bmp

Ernesto

ASKER

sum all the bellow number if the above says "si"

ASKER CERTIFIED SOLUTION

Edward Pamias

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Edward Pamias

I should have formatted the sheet better. The total is 20 and that's where the formula is.

=SUMIF(A1:F2,"yes",A2:F2)

A1:F2 is the whole array "Yes" is the criteria, A2:F2 is what you want the sum up.

Ernesto

ASKER

Thats, it!!!!
tsm

Ernesto

ASKER

what happend if the rang is not consecutive?

=SUMAR.SI(A1,c1,e1"yes",A2:c2,e2)
what is the way?
regards

Edward Pamias

post an example of how you are setting up the sheet. Or just take my sheet and modify it the way your sheet is setup.

Ernesto

ASKER

ok send you
is like yours
but the numbers are not consecutive
i need a6,d6,g6,,j6
with your same concept
regards!!
samplesheet.xlsx

Edward Pamias