Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question
is this an excel file?
ok, I would like to see an example of your data
if you click the paperclip icon at the top of this chat
you should be able to attach an example
I will try attachment
Hmm, not sure I'm following the image attachment instructions.
can we work from what I just sent you
The sample I sent is the data table and I want to pull from a lookup table the total cost
what you paste comes as text
if you want the formula to work the actual sheet is best
try this site
after uploading they give you file ID#
paste that here
The paperclip says its to attach an image not a file
yes i know
its bad design
but it works on files too
Send twice cause it didn't look like it worked
both are the same
can you actually open that?
ok its open
so you are loooking for the sum total from the table in columns L and M
that are within each date range?
tried vlookup but will only let me pick one of the dates from the table on the left. Don't know how to get it to look at both
give me a minute to get it
you can download the modified file from this linkhttp://ge.tt/7zOTIM01/v/0?cI hope this is what you need, if not, I can make changeslet me know if you have any questions, comments, or concernsIF YOU HAVE A MINUTE, PLEASE REMEMBER TO RATE MY SERVICE SO I GET PAID FOR MY TIMEYOU DO SO WITH THE SMILEYS BENEATH THIS CHATTHANKS
after clicking the link, click the blue download button to get the file
No, not looking for the sum. The cost should just be applied once to the range as is.
so for example, the range of 1/29-2/4 should have total of $4,931.25
let me check that
oh, wait you are right
so you are just looking for a single value for each date range
I was told there wasn't any overlap but there is
Im always right
but I will do whatever you need
ok, sounds like this is what you were looking for then
if you need any modifications you can always let me know
IF YOU HAVE A MINUTE, PLEASE REMEMBER TO RATE MY SERVICE SO I GET PAID FOR MY TIMEYOU DO SO WITH THE SMILEYS BENEATH THIS CHAT
Great - thanks so much!
BTW, I think you're service was excellent but your interface for files is poor