=SUMPRODUCT(--(Range1=value1),--(Range2="value2"),Range2Sum)

--
__________________________________
HTH

Bob

"Longhag" wrote in message
...
David,

Thanks for your response. Could you explain a little further how this one
will work?

Cheers
G

"David Biddulph" wrote:

SUMPRODUCT is likely to be the best bet.
--
David Biddulph

"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