Condensed IF function - EXCEL -

Condensed IF function - EXCEL -

how condense function?

=sum(if(b2="cash",d2,0)+if(b3="cash",d3,0)+if(b4="cash",d4,0)+if(b5="cash",d5,0)+if(b6="cash",d6,0)+if(b7="cash",d7,0)+if(b8="cash",d8,0)+if(b9="cash",d9,0))

it asks if b2 has value "cash" value of d2, else has value of 0. want every cell in column b , d can add together them up? how this?

please try:

=sumif(b:b,"cash",d:d)

excel function if-statement