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

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....

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

seems like some formulae might be used

can you provide an example of data?


On 14 Sty, 14:10, Dave Eade
wrote:
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....

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

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

Thanks anyway.

"Jarek Kujawa" wrote:

seems like some formulae might be used

can you provide an example of data?


On 14 Sty, 14:10, Dave Eade
wrote:
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....