subtotal in worksheet

[fuberator]

Hi

 

1. Is it possible to dynamically calculate a subtotal (count*price) for each of my summarised items?

 

 

 

2. How can I add a string to my sums, something like: =SUM(D2) + "total $ " and =SUM(E2) + "total lbs "

Edited May 7, 2020 by fuberator

[Pat Stanford]

Subtotal should just be a formula in D2 of   =B2*C2

 

D2 and E2 will already have the Sum, so in a cell outside of the database row you should be able to enter a formula like:

 

=Concat(D2, ' total $')

 

=Concat(E2, ' total lbs')

 

[fuberator]

Hi,

 

That does not give me the individual subtotals, i dont understand the result at all. Am i doing it in the wrong place (directly in the selected header)?

 

Edited May 8, 2020 by fuberator

[Pat Stanford]

In the Subtotal Column make sure the Sum Values check box is set in the pull down menu.

 

[fuberator]

yep that was it for the sum. thank you! Still no luck with the concat command. I cant seem to get it accepted as a formula

 

Edited May 10, 2020 by fuberator

[Pat Stanford]

I think you need to use semicolons between the parameters in the concat. I didn't pick up on your using commas (,) as your decimal point versus the period (.) we use in the US.

 

=Concat(D2; ' total $')