View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kallu kall kallu kall is offline
external usenet poster
 
Posts: 1
Default Sum only for one month in excel

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.