Search : in
By :

How to get data in excel only for one month

kallu, on Dec 16, 2008 3:05:23 pm GMT 
 Report this message to moderators

Hello,=SUMIF(Sheet1!D:D,Sheet2!C5,Sheet1!S:S) with this formula I have sum for one year,In sheet1 i have data for one year.
How cen I get this data only for one month from sheet1 to sheet2.
Thanks.

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « How to get data in excel only for one month » in :
Copy required data from one excel to anther Show
Move Data From One Tab To Another Show
Transferring data from one hard drive to another Show Transferring data from one hard drive to another First of all you should use some tools.. transfering data from one hard drive to another is quite simple. Once you have connected the new hard drive to your pc, check your...
Adding data from one column using another ShowAdding data from one column using another Issue Solution Note Issue I am having a real problem with an Excel formula. I have a worksheet with variable rows and a number of columns. I need to add together the values of particular...
Mktime() - Timestamp yesterday, last month, etc.). ShowMktime() - Timestamp yesterday, last month, etc.) Intro Last 24 hours Yesterday This week Last week This Month Last 30 days (last 30 days) Last month Current year(this year) Last year (last year) Intro The mktime()function...
How to read a file line by line ShowHow to read a file line by line Intro Tips Bonus Intro One of the most common errors of learning scripts bash on GNU / Linux is to read a file line by line, is to use a loop "for" (for line in $ (cat file.txt) do. ..), which in this...
Ask your question Reply
They need your help