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

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

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