Sum only for one month in excel
You could do it this way:
=SUMPRODUCT(--(MONTH(Sheet1!D$1:D$100)=Sheet2!C5),Sheet2!S$1:S$1 00)
where C5 contains a month number (1 to 12). If you have more than one
year's worth of data then you will need another condition to catch the
year.
Note that with SUMPRODUCT you can't use full-column references (unless
you have XL2007).
Hope this helps.
Pete
On Dec 16, 7:45*pm, kallu kall wrote:
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.
|