SUMIF Based on two criteria

[ShaneUK]

Hi

Am trying to do a SUMIF based on two criteria, where the first criteria is based on a date.

Basically, in column B is a date, column C is a title, and column D has an amount. I am trying to find a forumla that will add all of Column D but only if column B is equal to or more than 1st of the month (say October) and equal or less than the last day of month (so in this case 1st October - 31st October). Also Column C would say need to equal X and not Y or Z

Can someone please help me!!

Thanks

Shane

 

[acw]

Shane

Have a look at the SUMPRODUCT function. Search through the board for some examples you could modify to suit your structure.


Tony

 

[Aladin Akyurek]

Hi

Am trying to do a SUMIF based on two criteria, where the first criteria is based on a date.

Basically, in column B is a date, column C is a title, and column D has an amount. I am trying to find a forumla that will add all of Column D but only if column B is equal to or more than 1st of the month (say October) and equal or less than the last day of month (so in this case 1st October - 31st October). Also Column C would say need to equal X and not Y or Z

Can someone please help me!!

Thanks

Shane

=SUMPRODUCT(--($B$2:$B$400-DAY($B$2:B$400)+1=F2),--($C$2:$C$400=C2),$D$2:$D4400)

where F2 houses a month/year of interest entered as the first day date like 1-Oct-2006 and G2 a title of interest.