Separating Names and Monies

[Jim Baker]

I Have a column G with Peter, Chris and Robin who have been paid monies
at various times which has been entered in Column H.
Underneath, I have seperately put their names in their own cell with
the formula below to show the individual amounts, but I get value
error message.
Would be grateful for some help.
Thanks
Jim

=IF(G26:G36="Peter",SUM(H26:H36),"0")
=IF(G26:G36="Chris",SUM(H26:H36),"0")
=IF(G26:G36="Robin",SUM(H26:H36),"0")

 

[Laura Cook]

=SUMIF(G26:G36,"Peter",H26:H36)