Hi I am new to this forum and would really appreciate it if some one could help me. I am trying to lookup a shop name in a worksheet and derive how many days of the week it made a sell from looking up another workbook. Please note that shops names are not in order so I thought a formula with a countif and vlookup could work, but I cant get it seem to work.
Please see attachment for what I am trying to achieve.
Many thanks in advance for your help.
Hi and welcome to the forum.
In your example workbook, enter
=SUMPRODUCT(($C$27:$C$33=C14)*($D$27:$J$33>0))
in cell D14, and copy down.
Please disregard anything in the above post. It may well have been edited without my consent, as has been the case with several posts and threads recently.
Welcome to the forum, this is the Access Section, the Excel Section is above thanks.
Thanks whoever moved this out of the Access Section
Last edited by split_atom18; 08-24-2010 at 04:13 PM. Reason: Edited because post was moved.
"I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
If my advice has been helpful to you, then please help me by clicking on the "Star" and adding to my reputation, Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks