Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum by month and year
I am trying to get daily totals sumed and put into a monthly
worksheet. I have been using SUMIF comparing the month and year of each payment. Here is the formula. =SUMIF(MONTH(Payments!b7:b3000)&YEAR(Payments!b7:b 3000), MONTH(B39)&YEAR(B39),Payments!F7:F3000) Excel is saying there is an error but when I look art the edit formula area is seems to calculating correctly. Can you help me? Steve |
#2
|
|||
|
|||
You can use sumproduct without the CSE
=sumproduct((month(dr)=month(b39))*year(dr)=year(b 39))*sumrng) -- Don Guillett SalesAid Software "Steven Robilard" wrote in message ... I am trying to get daily totals sumed and put into a monthly worksheet. I have been using SUMIF comparing the month and year of each payment. Here is the formula. =SUMIF(MONTH(Payments!b7:b3000)&YEAR(Payments!b7:b 3000), MONTH(B39)&YEAR(B39),Payments!F7:F3000) Excel is saying there is an error but when I look art the edit formula area is seems to calculating correctly. Can you help me? Steve |
#3
|
|||
|
|||
Try this:
=SUMPRODUCT((TEXT(Payments!B7:B3000,"mm/yy")=TEXT(B39,"mm/yy"))*Payments!F7: F3000) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Steven Robilard" wrote in message ... I am trying to get daily totals sumed and put into a monthly worksheet. I have been using SUMIF comparing the month and year of each payment. Here is the formula. =SUMIF(MONTH(Payments!b7:b3000)&YEAR(Payments!b7:b 3000), MONTH(B39)&YEAR(B39),Payments!F7:F3000) Excel is saying there is an error but when I look art the edit formula area is seems to calculating correctly. Can you help me? Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP - need to returns the current number of past month this year and ... | Excel Worksheet Functions | |||
sort dates by month and day not year | Excel Worksheet Functions | |||
Month Year Date Format | Excel Worksheet Functions | |||
How to sort by day and month while ignoring year? | Excel Worksheet Functions | |||
Insert Month and Year in my worksheet | Excel Worksheet Functions |