Sumifs in excel 2003

[fraufreda]

I am using the following function in 2007
=IF(E237="","",SUMIFS('General Ledger'!$G$6:$G$1048576,'General Ledger'!$A$6:$A$1048576,E237,'General Ledger'!$F$6:$F$1048576,"<>Current Period Change"))

but when saving the file into 2003 i receive incompatibility msg concerning the number of rows and sumifs function.
Okay I reduced the number of rows but I am struggling to get around other problem. I am wondering if you could help me creating UDF with the same format of sumifs i.e.(sum_range,criteria_range1,criteria1,...). or maybe give me some other solution.
thanks

 

[GlennUK]

How about:

=IF(E237="","",SUMPRODUCT(('General Ledger'!$G$6:$G$65536)*('General Ledger'!$A$6:$A$65536=E237)*('General Ledger'!$F$6:$F$65536<>"Current Period Change")))