which formula to use?

[Sahana Kamat]

Please see the attached data. I am looking for a formula which will help me add up all the values of the region starting with the particular series. i.e the total sale PCG1 should tell me the sum of all the series starting with PCG1 which is
PCG10
PCG12
PCG13
PCG14
PCG15
PCG16
PCG18
PCG19


And the field others should add the rest of the region sales which start with PRC.

I have tried to create this dashboard using Vlook up and sum if but not getting the correct formula. Can you ninjas please help me out ?
P.S: I want the total sales to show up a value even when i Add up more nodes in the list.

 

[Nebu]

Hi:

Please find the attached.

Thanks

 

[Sahana Kamat]

Thank you very much for the quick reply Nebu. what about the formula for the addition of Others in "Total Sales" table ? I do not see a formula for that .

 

[NARAYANK991]

Hi ,

Try this :

=SUM($B$2:$B$40) - SUM($F$2:$F$9)

Narayan

 

[Nebu]

Just copy those Regions down and drag the formula.
Oh My bad Narayan has already given you the solution.
Thanks

 

[Sahana Kamat]

Thank you both of you for the help !