Thread: Help with SUMIFS
View Single Post
 
Old 05-27-2016, 07:42 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default
Quote:
Originally Posted by jeffreybrown View Post
Hi Tony,

Try

=SUMPRODUCT(--(MONTH($C$1)&"|"&YEAR($C$1)=MONTH(Sheet1!$E$6:$E$1 4)&"|"&YEAR(Sheet1!$E$6:$E$14)),--($A3=Sheet1!$A$6:$A$14),Sheet1!$I$6:$I$14)
Brilliant - many thanks Jeffrey.
Reply With Quote