Excel 2003 alternative for SUMIFS()

[prateek.17]

Hi,
I am using a formula in excel 2007 and i want it to work in excel 2003 as well and i need some help.
SUMIFS('Area Pivot'!O:O,'Area Pivot'!$A:$A,$B8,'Area Pivot'!$B:$B,$B$2))

Thanks

 

[berk04]

Hi, I'm using this formula on Excel 2010 and I would like to use it on Excel 2003 too. Thanks!

=SUMIFS(P109:P116,Q109:Q116,1,P109:P116,"<>#VALUE!",P109:P116,"<>#N/A")

 

[Matt Rogers]

Double:

http://www.mrexcel.com/forum/excel-...-sumifs-formula-excel-2003-a.html#post4007529

Matt

 

[ziko111]

Hi guys,
I use this formula in Excel 2010 =SUMIFS(Sheets1!J3:J3000, Sheets1!C3:C3000, ">=1/1/2015", Sheets1!C3:C3000, "<=1/31/2015") and it works great, but I want to use this formula in Excel 2003. Please help. Thank you.