I have three months sales report on three different sheets and I want to automatically generate a fourth sheet with the list of items and showing me separetly the jan feb and mar sales for each of the items in diff columns (like in the attachment). I just cannot figure out how to do it. Not that i really know much about excel to do it on my own..lol
G'day,
I've applied the vlookup formula.
It's wrap in a IF and ISNA formula. The IF formula is for if there no product no. it will return blank, and the IF(ISNA() formula so if the product not in the list of that month is return a zero or no sales.
Hope this helps
Edit: Driving home in the car and I was thinking. The formula supplied will only work on the first entry of the product code. If multiple entry of a product in one month use a sumif formula
Example for the Jan Sales. Place in C3 on the sheet 4 and copy down
=SUMIF('SALES JAN 08'!$A$2:$A$1000,A3,'SALES JAN 08'!$C$2:$C$1000)
Last edited by ratcat; 06-16-2008 at 04:45 AM.
Have I made you happy ??? If yes, please make me happy by pressing theAdd Reputation button in my post.
Please don't forget to do the same to other contributors of this forum.
ThanksI don't void confusion, I create it
Oh kool!! I can get it work for the sales figures. Thanks but i also want to get the 'Part No' & Description automatically rather than me having to copy it or type it. Basically i want in sheet 4 the list of items which have had any sales in Jan or Feb or Mar
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks