Excel ... Sumif problem

  Simsy 19:06 10 Jan 2010
Locked

Folks,

Excel 2007

I have two named ranges, "Dates" and "Payments" which are both columns.
I also have a named cell, "Payday" which has a numerical value, (which may be from 1-31)

I am trying to sum the total of payments made on a specified day of each month... eg if the value of "Payday" is 20, I want to sum the payments made on the 20th Jan, 20th Feb, 20th Mar etc.

I have the following formula;

=Sumif(Dates,Day()=Payday,Payments)

which should sum all the relevant cells in the Payments column, when the date in the dates column is the same day as in the Payday cell...

I hope that makes sense...

I am not getting an error when I enter the formula, but I am getting a result of 0 which is incorrect.

Can anyone advise? I suspect I'm doing something wrong with the criteria, but I'm having a mental blank and can't see how to correct it.

(I've got a horrible feeling that if this isn't the case It's goin to need some other calculation such as "sumproduct", which I just can't get my head around!)

Thanks in advance,

Regards,

Simsy

  Simsy 19:48 10 Jan 2010

being looked at on an Excel forum, so I'll close this!

Please don't refrain from posting however!

Regards,

Simsy

  Simsy 19:49 10 Jan 2010

click here

Regards,

Simsy

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017