SUM IF DATE IN IN THAT MONTH

[superstarr]

hi
need a little hlp pls
have a range of dates, ie 3/11/2004
would like to have the sum of all the dates by month
tried the sumif, but cant figure out how to tell formula that 3/11/2004 is in march so add to the march total

thx much

JOn

 

[brbell01]

@brbell01

1. If a year test is not needed: Control+shift+enter, not just enter...

=SUM(IF(MONTH($A$3:$A$2000)=7,IF($C$3:$C$2000="bella",$B$3:$B$2000)))

2. If you have the SUMIFS function on your system: Just enter...

=SUMIFS(B:B,C:C,"bella",A:A,">="&DATE(2016,7,1),A:A,"<="&DATE(2016,7,31))

This solution worked perfectly thanks so very much, Aladin.

 

[Aladin Akyurek]

This solution worked perfectly thanks so very much, Aladin.

You are welcome. Thanks for the update.

 

[sdm100]

I have a slight tweak that I need some help with, I am using the below formula to sum the 'liftings' (a quantity) inV:V if the date of lifting (stored in B:B) is within the month shown in A4 in the current tab.

All seems to be working well using the advice above, but I'm like to only sum if the lifting has occured (rather than scheduled to occur) so I have a Y / N cell in the Liftings tab under A:A...I'd like the formula to first check that the Lifting is marked as Y then perform the sum...

e.g. 3 equal liftings 1000 units in the month referenced in A4, 2 liftings are marks Y; I'd like to show 2000...and as soon as I flick N to Y it will show 3000

Can anyone help amend the below?

Thanks,


=SUMIFS(Liftings!V:V,Liftings!B:B,">="&A4,Liftings!B:B,"<="&EOMONTH(A4,0))

 

[Fluff]

How about
=SUMIFS(Liftings!V:V,Liftings!B:B,">="&A4,Liftings!B:B,"<="&EOMONTH(A4,0),Liftings!A:A,"Y")

 

[sdm100]

I am slightly embarrassed I didn't think of that myself, but so grateful that this works perfectly! Thanks for the quick reply!

 

[Fluff]

You're welcome & thanks for the feedback.