Pivot Table? Formula?

  • Thread starter Thread starter twinkle17
  • Start date Start date
T

twinkle17

I need a formula/pivot table assistance to obtain totals of values against
cost centres.

I have cost centres in column L with corresponding values in column O.
(Same for columns P & S, T & W, X & AA.

I need the values in columns O, S, W & AA to autosum based on the criteria
in columns L, P, T & X.

Ie. L7, L8 & L15 have cost centre of 6010, then I need to sum all values in
O7, O8 & O15.

Help is appreciated!

Thanks
 
I need a formula/pivot table assistance to obtain totals of values against
cost centres.

I have cost centres in column L with corresponding values in column O.  
(Same for columns P & S, T & W, X & AA.

I need the values in columns O, S, W & AA to autosum based on the criteria
in columns L, P, T & X.

Ie. L7, L8 & L15 have cost centre of 6010, then I need to sum all values in
O7, O8 & O15.

Help is appreciated!

Thanks
Click to expand...

Hi,

If I understand you correctly you have different cost centre codes in
different columns, L, P, T & X.

Is that correct? If so, is it not possible to have all those cost
centres in the same column?

Then the pivot table would auto sum for you.

If not then you cant do what you want within the pivot table but you
could try this formula elsewhere on the sheet

=SUMIF(L:L,"6010",O:O)

Regards

David
 
David Heaton said:
Hi,

If I understand you correctly you have different cost centre codes in
different columns, L, P, T & X.

Is that correct? If so, is it not possible to have all those cost
centres in the same column?

Then the pivot table would auto sum for you.

If not then you cant do what you want within the pivot table but you
could try this formula elsewhere on the sheet

=SUMIF(L:L,"6010",O:O)

Regards

David
Click to expand...
*****************************************************
Thanks David, worked great, I just added another SUMIF to the formula for
the 4 sets of columns.

Cheers
 
*****************************************************
Thanks David, worked great, I just added another SUMIF to the formula for
the 4 sets of columns.

Cheers- Hide quoted text -

- Show quoted text -
Click to expand...

your welcome.
 
Back
Top