format for table

**batjl9** · 09-01-2009, 03:15 PM

Hi guys

I have attached a chart I have set up, but i was wondering if i am able to link the 'total bought' chart on the right hand side with column B 'owner name', so that it automatically adds up how many rows each name is in. I have set the 'total bought' chart up manually so you can see what I am after. I am guessing it is some sort of formula, but unsure of which myself.

Any help would be greatly appreciated.

Thanks
Gemma

**DonkeyOte** · 09-01-2009, 04:30 PM

See COUNTIF in XL Help, eg:

O2: =COUNTIF($B:$B,$N2)
copied down

Alternatively perhaps think of using a Pivot Table (see link in sig for basic intro.)

**batjl9** · 09-01-2009, 05:49 PM

thanks alot that worked perfectly.

**royUK** · 09-02-2009, 03:10 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**batjl9** · 09-03-2009, 03:28 AM

Hi

I have one more question if possible please. I have amended the chart with information in the grading and class columns. Is there any sort of formula that can be used which can total up in the 'total bought' chart on the right hand side from the 2 rows comined. I am looking at finding the total G1A bought, G1B, G2B, G2C and G2D bought. Not sure if it is possible because there are different numbers next to the letters. Are you able to have a formula which incorporates something like 'begins with A,B,C,D etc?

Thanks
Gemma