Hi, I'm wondering if there is a way to use a sum or vlookup value to what I'd like to do.
I've attached a sample.
I know that sumproduct can be used to return total of multiple lookups in a table. However, my lookup table includes spaces in between the values being looked up, so it messes the formula up.
any help would be hugely appreciated
Thanks
Hi Silverscreen
find the attatch file with formula
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Hi Azam,Originally Posted by Azam Ali
Thanks for help again, it looks good but for cell B3, i only want it to return results from Sheet 2 in column C (matching the dates in the title). i did copy this formula into my sheet using the correct arrays and only selected one column for the value to look for if true. but this didn't seem to work, it returned no numbers
Thanks.
Hi Azam,
Thanks for your help but I figured it out, it was an error on the spreadsheet that was preventing the formula from working, thanks a lot!
Last edited by Silverscreen; 07-25-2011 at 11:02 AM.
Hi Silverscreen
find the attatch file with sumproduct and sumif function
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks