| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum formula
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum formula
=SUMPRODUCT(--(LEFT(A1:A100,5)="arral"),(B1:B100))
-- Gary''s Student - gsnu200834 "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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum formula
Thanks Gary
"Gary''s Student" wrote: =SUMPRODUCT(--(LEFT(A1:A100,5)="arral"),(B1:B100)) -- Gary''s Student - gsnu200834 "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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum formula
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
