Sum of sales based on first letter of name

[rkr]

Hi folks,

I have a requirement like this..
PFA

I would like to get the sum of sales generated by Sales persons whose name starts with letter "j".

This is the formula that i have written to achieve this...

=IF(LEFT(A2,1)="j",SUM(E2:E14),0)

i think my formula is correct for a single cell. But i need to consider a cell range to check the sales person names.

Please suggest me how can i achieve this.. correct me if my formula is wrong..

regards,
rk

 

[bobhc]

Good day rk and welcome to the forum if you have not already done, please read this link it will help in the use of the forum

As to your question why not just use a table, then you can filter on any name or column or combination.


.

 

[NARAYANK991]

Hi ,

Try using the SUMIF function , since it can accept wildcards , as in :

=SUMIF($A$2:$A$13,"J*",$B$2:$B$13)

Narayan