Hi everyone,
I am new to the forum and newbie for calculating in excel, so I've been having trouble finding a solution for this problem.
i have this "rep. purchase" sheet and taking data from '"purchase"
what i want is sum for example product (beeswax) i buy can be showed and calculated in "purchase" sheet
Last edited by blueboi0604; 03-02-2017 at 02:02 PM.
in Rep PURCHASE!G10
=SUMPRODUCT((PURCHASE!C$5:C$500=C10)*(PURCHASE!G$5:G$500))
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi -
I used SUMPRODUCT to add up the purchases by item. The formula looks like this:
=SUMPRODUCT((PURCHASE!$C$5:$C$176=[@[PRODUCT NAME]])*PURCHASE!F$5:F$176)
You can also use SUMIF if you prefer. SUMIF has a little less computational overhead than SUMPRODUCT. So if your spreadsheet gets very large you may want to consider SUMIF.
Attached is your spreadsheet with the above formula.
Hope this helps.
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
Originally Posted by Special-K
thank you very much for your help
Can't believe its so simple, im just so dumb for not realizing it :D
thnks
It's only simple if you know how to do it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks