SUMIF

[bfraser]

=SUM(SUMIF('February 3, 2014'!$L$2:$L$58,D4,'February 3, 2014'!H2:H58)+(SUMIF('February 3, 2014'!$M$2:$M$58,D4,'February 3, 2014'!H2:H58)+(SUMIF('February 3, 2014'!$N$2:$N$58,D4,'February 3, 2014'!H2:H58))))

Is there an easier/neater formula than this?

 

[NARAYANK991]

Hi Fraser,

Try this :

=SUMPRODUCT((--(D4=Sheet1!$L$2:$N$58))*(Sheet1!H2:H58))

Narayan

 

[Haseeb A]

Or,

=SUM(SUMIF(OFFSET('February 3, 2014'!$L$2:$L$58,,{0,1,2}),D4,'February 3, 2014'!$H$2:$H$58))

 

[pecoflyer]

OFFSET being volatile might slow things down