I am using
I am bugged to edit the formula to change 216 to another code
Please Login or Register to view this content.
This is wasting time
See file attached my n2 to be modified do the sales summing according to codes on column O and then drag down
To be utilised to arrive to sales by category of stock series
If the answer is correct it should arrive to the following sales
Please Login or Register to view this content.
Use this
=SUMIF(D:D,O2&"*",I:I)
and pull formula down
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
This is it I was writing it without the quote in the morn, lovely
Please Login or Register to view this content.
Last edited by makinmomb; 05-05-2015 at 12:19 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks