Jump to content
fuberator

subtotal in worksheet

Recommended Posts

Hi

 

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

 

 

1269101163_Screenshot2020-05-07at17_13_52.thumb.png.8aa627acfe1cd327939d4ce78d38a0e8.png

 

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

Edited by fuberator

Share this post


Link to post

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')

 

Share this post


Link to post

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)?

 

1084112689_Screenshot2020-05-08at13_55_18.thumb.png.0041cf92c0f213241c84cde65a8ad8cd.png

Edited by fuberator

Share this post


Link to post

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

 

1576191447_Screenshot2020-05-10at16_07_41.thumb.png.14d7fe22d828e28d37e1c1b4d6ddacf0.png

Edited by fuberator

Share this post


Link to post

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 $')

 

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×
×
  • Create New...