sumif or sumproduct

[jigpadia]

hi peeps,

i got an issue with suming up something.

SOMERFL'D/KWIKSAVE 64627 62008
*FIELD MANAGED 43187 39609
LE CAT DELIVERED W/S 42728 58791
HOTELS & PUB GROUPS 36330 23561
*LEISURE NATIONALS 35936 38146

say i wanna sum up the names in row 2 and 5 for figures in column C.
how do i go about it..

appreciate your help...

 

[Alex Delamain]

Try this

=SUMPRODUCT((LEFT(A1:A5,1)="*")*(C1:C5)