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