SOLVED

SUBTOTAL in the LIST is not working

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3148460%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ESUBTOTAL%20in%20the%20LIST%20is%20not%20working%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3148460%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi%20all%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20am%20having%20a%20file%20with%20the%20total%20to%20be%20added%20from%20column%20cells%20H9%3AH29.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ESubtotal%20is%20going%20to%20be%20in%20cell%20H30.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThe%20subtotal%20in%20the%20same%20cell%20should%20be%20a%20list%20containing%2C%20SUM%2C%20AVERAGE%2C%20MIN%2C%20MAX%2C%20COUNT%20and%20Any%20other%20needed.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EWhen%20i%20click%20on%20the%20Cell%20it%20should%20populate%20a%20dropdown%2C%20where%20it%20should%20show%20the%20functions%20as%20above.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EFrom%20the%20list%2C%20as%20i%20click%20on%20the%20SUM%2C%20it%20should%20show%20the%20total%20value%2C%20similarly%20for%20Average%2C%20Min%2C%20Max%20and%20Count.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EPlease%20guide.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3148460%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3ECharting%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3148460%22%20slang%3D%22en-US%22%3ESUBTOTAL%20in%20the%20LIST%20is%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3148460%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20a%20file%20with%20the%20total%20to%20be%20added%20from%20column%20cells%20H9%3AH29.%3C%2FP%3E%3CP%3ESubtotal%20is%20going%20to%20be%20in%20cell%20H30.%3C%2FP%3E%3CP%3EThe%20subtotal%20in%20the%20same%20cell%20should%20be%20a%20list%20containing%2C%20SUM%2C%20AVERAGE%2C%20MIN%2C%20MAX%2C%20COUNT%20and%20Any%20other%20needed.%3C%2FP%3E%3CP%3EWhen%20i%20click%20on%20the%20Cell%20it%20should%20populate%20a%20dropdown%2C%20where%20it%20should%20show%20the%20functions%20as%20above.%3C%2FP%3E%3CP%3EFrom%20the%20list%2C%20as%20i%20click%20on%20the%20SUM%2C%20it%20should%20show%20the%20total%20value%2C%20similarly%20for%20Average%2C%20Min%2C%20Max%20and%20Count.%3C%2FP%3E%3CP%3EPlease%20guide.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3148460%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

Hi all,

 

I am having a file with the total to be added from column cells H9:H29.

Subtotal is going to be in cell H30.

The subtotal in the same cell should be a list containing, SUM, AVERAGE, MIN, MAX, COUNT and Any other needed.

When i click on the Cell it should populate a dropdown, where it should show the functions as above.

From the list, as i click on the SUM, it should show the total value, similarly for Average, Min, Max and Count.

Please guide.

1 Reply
best response confirmed by gazenesh (Visitor)
Solution

@gazenesh What you are describing seems to be the Total Row in a structured table. Transform the range with numbers to a structured table (Ctrl-T or "Format as Table" on the Home ribbon).

Riny_van_Eekelen_1-1644492490612.png

Now check the Total Row box on the Table Design tab.

Riny_van_Eekelen_0-1644492385940.png