Pivot Table? Formula?

[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

 

[David Heaton]

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

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

 

[twinkle17]

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

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

Cheers

 

[David Heaton]

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

your welcome.