Microsoft Office Forums - View Single Post - Help with SUMIFS

Thread: Help with SUMIFS

View Single Post

Old

05-27-2016, 07:26 AM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

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)

Reply With Quote