Translation of SUMIFS Excel 2007 Formula to an Excel 2003 compatible formula

[Lambrix]

I am trying to translate the following formula into an array that will have the same function, but will be cross compatible with all versions of Excel. From what I have read online, you need to create an array in order to accomplish this. Does anybody know how to translate the formula below? I have added two examples of the same formula.

=SUMIFS('SharePoint List Inputs'!E:E,'SharePoint List Inputs'!C:C,"June",'SharePoint List Inputs'!F:F,"IDT")

=SUMIFS(E:E,C:C,"June",F:F,"IDT")

 

[VoG]

Look hee http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[FormR]

=sumproduct(E1:E1000,--(C1:C1000="June"),--(F1:F1000="IDT"))

Note: you cannot use absolute column references with sumproduct in XL2003