01-05-2013, 12:58 PM
|
Novice
|
|
Join Date: Jan 2013
Posts: 2
|
|
Here is how is should work See Attach bill101 =SUMIFS
Quote:
Originally Posted by Kevin@Radstock
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
|
Here is how is should work See Attach bill101 =SUMIFS
|