Help with order form auto sum with VLookup?

[willgarratt]

Hi, 

I need help creating a formula which will add up how much each player owes based on their order as below.  Not sure if I have the right formula for a start?

[#2 · Accepted solution]

@willgarratt 

=SUMIF(B2:M2,"<>"&"",$B$1:$M$1)

You can try SUMIF.

 

[#3]

Awesome thank you!