i dont know the formula that i need to use with my sales report.. Can you help me with this.. kindly see the attched file.sales report2.xlsx
i dont know the formula that i need to use with my sales report.. Can you help me with this.. kindly see the attched file.sales report2.xlsx
Last edited by mimzkie1101; 07-27-2012 at 05:48 AM.
Hi
The formula you need in cell E8 is
=SUMIF($K$8:$K$16,B8,$M$8:$M$16)
copy down through E9:E16
But first, change the values in M2:M13 to be values, not formulae, otherwise you will get a circular reference problem.
--
Regards
Roger Govier
Microsoft Excel MVP
Mimzkie,
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks