Separating Names and Monies

  • Thread starter Thread starter Jim Baker
  • Start date Start date
J

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")
 
Back
Top