I think I need a Pivot Table ,but not sure....

[Dave Eade]

I have a work book that has about 20 colums.
3 of the colums are "stage" "Company" and "value" - they are not next to
each other.
each row has a value in stage and company [ predefined from Data valiidation
tables] some have a value some don't.

I can use pivot table to do simple counts of a list of Stage 1-9 and how
many rows have each, or based on company.

What I want to do next is have a table that shows the sum of the values for
each stage, and anothe pivot table for sum of values for company.

Is this possible?

Thanks in anticipation....

 

[Jarek Kujawa]

seems like some formulae might be used

can you provide an example of data?

 

[Dave Eade]

Ok, I think I've sorted it now by "trial & error".

Thanks anyway.

seems like some formulae might be used

can you provide an example of data?

I have a work book that has about 20 colums.
3 of the colums are "stage" "Company" and "value" - they are not next to
each other.
each row has a value in stage and company [ predefined from Data valiidation
tables] some have a value some don't.

I can use pivot table to do simple counts of a list of Stage 1-9 and how
many rows have each, or based on company.

What I want to do next is have a table that shows the sum of the values for
each stage, and anothe pivot table for sum of values for company.

Is this possible?

Thanks in anticipation....