Dear Sir,
I wish to get Sum of NO_DEFINITE_ROOMS & Sum of TOTAL_REVENUE date by date only if E:E is matched to A:A on Sheet4. This data I used to paste on daily basis. Is there any possibility if I chage the date. Then data automatically picks up from that range
FInd the attached sample sheet
Regards,
Gulzar
Last edited by gulzar_7862002; 01-29-2013 at 06:06 AM.
Where?...FInd the attached sample sheet.................
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Gulzar,
To Attach a File:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.
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]
Same has been sorted by SUMIFS formula - Thanks forum Team
So you need to update in your profile the Excel version that you use!
Because SYMIFS does not works in Excel 2003!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks