E-Mail 'Sum unique numbers' To A Friend
Email a copy of 'Sum unique numbers' to a friend
Loading ... Loading ...5 Responses to “Sum unique numbers”
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
I have given up trying to figure out the following problem as it seems over my head, and am
hoping there is a kind soul out there can help me out with the solution.
I am trying to setup a spreadsheet to make calculations which are then exported to Quickbooks.
The original data is returned to Excel from an Access database by msq. Each record relates to an order number and is tied to a
product, and there may be more than entry for each order number as an order may have more than one product.
The actual data import sheet looks something like this:
OrderNumber ItemNumber Date Product PricePerUnit CostPerUnit
4967 1 10-May-10 widget 430.92 306.00
4967 2 10-May-10 doohickey 256.33 165.00
4968 1 11-May-10 doohickey 256.33 165.00
The actual data export sheet looks something like this:
Date Name Account Account Type MEMO Split Account Amount
10-May-10 vendor1 Bank Credit Card 4967 Cost of Goods Sold -306.00
10-May-10 vendor1 Bank Credit Card 4967 Cost of Goods Sold -165.00
11-May-10 vendor2 Bank Credit Card 4968 Cost of Goods Sold -165.00
My problem is that I cannot figure out how to return the total only, and not individual amounts, for orders
with more than 1 item. I.E., how can I tell excel to return each OrderNumber only once, along with
the total for each, like this:
Date Name Account Account Type MEMO Split Account Amount
10-May-10 vendor1 Bank Credit Card 4967 Cost of Goods Sold -471.00
11-May-10 vendor2 Bank Credit Card 4968 Cost of Goods Sold -165.00
There is a little more to this, as I am also trying to include shipping costs, but I Am still trying to
figure out how to return the data using msq, which I am finding a little quirky to use at all, but I have
managed to at least get it to work on a basic level.
Anyhow, is there anyone there who can help? I would be very grateful and much obliged.
Thanks in advance.
AJ
AJ,
see this post: https://www.get-digital-help.com/how-to-return-the-total-for-orders-with-more-than-one-item-in-excel/
Hi!
Let me say "Thanks" to you because you saved me, my next degree and my huge worksheet!
After countless hours looking for a feasible solution, I finally got here. May you be praised! :)
alemar,
Thanks!
How to calculate sum of unique values if the data is in another worksheet.
I get zero as the answer.
Any solutions pls