What formula

[Wimpie]

Hi please assist

Column A = Number of the branch/offsite e.g H917
Column B = Name of the branch/offsite e.g Main branch
Column C = Clasification e.g branch/offsite
Column D = Can be serviced as an branch/offsite e.g yes/no
Column E = Cash delivery e.g shared/dedicated
Column F = Average number of deliveries per week e.g 1 - 3
Column G = Kilometres from town e.g 1 to 200km's
Column H = Band 1 - 4
Cloumn I = Cost per band e.g band 1 = 247
Column J = Monthly cost per Band (colmn f*I*4)
Column K = Service provider e.g SSB/ Branch or Canister swop

I need to see diffrent senarious out of this if we can look at them one by one please.
1. I need to see the number of branches as follows 0-5km's from town, 5-50km's from town and 50km's plus from town but per service provider(column K), I need to see the same for the offsites.
If the service provider in column K is SSB the monthly cost in K needs to be shown as well.

 

[Andrew Poulsom]

Have you tried a pivot table?

 

[Wimpie]

No i have not. I need to see what the impact is when i change some of the information as well.
Can you give me a example

 

[Andrew Poulsom]

Look here:

http://peltiertech.com/Excel/Pivots/pivottables.htm