Hi,
Have sumifs function with different criterias.
The main idea is to sum all values between two dates filled in two cells. I've faild to link this cells to function. The only way i have is to fill it "by hands".
See attached file
Hope you'll help to fix it.
example.xlsx
Hi,
from an Excel 2000 user.
After trasformed in dates (using substitute and format) column B, I've used
Hope it helps
Please Login or Register to view this content.
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Thanks a lot.
Realy good alternative.
Hi, you can convert the data to date-format by using datevalue. Then change the formula to (almost) what you suggested:
Please Login or Register to view this content.
Was trying the same method, but it shows no results.
Thanks
Does this help?
Respected All,
After seeing your expertise in sumifs(), i thought of asking you my problem solution, i have attached a excel sheet, i want to extract data from data sheet to worksheet, it should extract data between two range of month, if sumifs() i wil l serve my purpose, please help
regards
juzar para
Parajf,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thank you for your advice, i am trying to add arlu1201 to my skype address, but it say not listed
parajf,
Why do you want to add me on skype? If you have a question regarding opening a new thread, you can PM me here or check the FAQ.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks