This is my Excel 2007 formula - how would I convert this into 2003:

=SUMIFS(I4:I302,A4:A302,1,G4:G302,"written")

'1' being the criteria in the first range, 'written' being the criteria in
the second range and I4:I302 is the sum range.

Thanks for your help

"Don Guillett" wrote:


As you have found, they are new to 2007. Try using sumproduct((etc. or the
array sum(if( etc.
Post your formula(s) if necessary.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Longhag" wrote in message
...
I have created a worksheet at home on Excel 2007 using 'sumifs' and
'countifs' formulae and when I have saved this (in .xls format) and then
opened it in Excel 2003 in work, it doesn't recognise this formula.

Is there a way of converting this appropriately or an alternative formula
I
can use for sum/count if command with multiple criteria

Thanks
G