Thread: [Solved] I need help with =SUMIFS
View Single Post
 
Old 01-05-2013, 12:58 PM
docwhit docwhit is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jan 2013
Posts: 2
docwhit is on a distinguished road
Default Here is how is should work See Attach bill101 =SUMIFS

Quote:
Originally Posted by Kevin@Radstock View Post
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
Attached Files
File Type: xlsx BILLS101.xlsx (62.0 KB, 10 views)
Reply With Quote