Thread: [Solved] I need help with =SUMIFS
View Single Post
 
Old 01-04-2013, 12:08 AM
Kevin@Radstock Kevin@Radstock is offline Windows 7 32bit Office 2010 32bit
Office 365
 
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default

Hi docwhit

Try the following in E21, copy across & down.

SUMIFS:
=SUMIFS($D$39:$D$50,$A$39:$A$50,">="&EOMONTH("01/"&$C21&"/2013",-1)+1,$A$39:$A$50,"<="&EOMONTH("01/"&$C21&"/2013",0),$C$39:$C$50,E$20)

Or a SUMPRODUCT:
=SUMPRODUCT(--(MONTH($A$39:$A$50)=$C21),--($C$39:$C$50=E$20),$D$39:$D$50)

Kevin
Reply With Quote