how to add more than 27 reference value in subtotal formula

[imran khan]

i have a excel sheet containing more than 27 values to be sum. i have to use subtotal formula. but after 27 values subtotal formula does not sum more value.


how can i solve this problem?

 

[GCExcel]

Do your 27 values to be sum are placed in 27 NON-adjacent cells ?

Instead of:

SUBTOTAL(1, A2, A3, A4)


you can write:

SUBTOTAL(1, A2:A4)


Otherwise, switch to Excel 2007 as you can use 254 references instead of 29.

;-)

 

[Hui]

or try Sumif or Sumifs