Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Try: =SUMIF(A1:A10,"arral*",B1:B10) -- If this helps, please click the Yes button Cheers, Shane Devenshire "ADIB" wrote: Hi, for instance A B arral bini 2000 rojar aoral 1500 arral d'costa 2000 i would like sum only name arral and it should be 4000. please suggest me how can i make formula. thanks |