Sum by month and year

S

Steven Robilard

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:b3000),
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
 
D

Don Guillett

You can use sumproduct without the CSE
=sumproduct((month(dr)=month(b39))*year(dr)=year(b39))*sumrng)
 
R

RagDyeR

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!
==============================================


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:b3000),
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Interest and Payment Calculations 6
Sum items occurring in a month and year 3
[CSE] SUM Array Formula with if condition 1
Excel 2002 : How to sum by month and year ? 3
Transfer of data 2
Year to date sum 5
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Running Sum of cell in many spreadsheets 1

Top