Thread: Sumproduct, skipping columns, addition

I have Names in column A, Data in Column B. Example

A1 John B1 1000 C1 5:32:05
A2 Jim B2 500 C2 5:56:55
A3 John B3 600 C3 6:45:65
A4 Bill B4 300 C3 7:21:05

In another column I have the names of all the possible people that I will need data from and next to them I will need a formula to tabulate all their totals from column B and then another formula that will skip B and total column C's total.. I have a formula that I used from awhile ago when I needed to offset the data but I can't figure out how to just take the data to the right of it and then another formula to skip column B. Here is my old formula =SUMPRODUCT(($A$1:$A$291=G14)+0,OFFSET($B$1:$B$291,1,0)+0)

Thanks for you help,
Jay

=SUMPRODUCT(($A$1:$A$291=G14)*$B$1:$B$16)

and

=SUMPRODUCT(($A$1:$A$291=G14)*$C$1:$C$16)