COUNTIFS and SUMIFS are new to Excel 2007.

Try

=SUMPRODUCT(--(Workflow!G9:G305="New Facility"),--(Workflow!S9:S305="Yes"))

=SUMPRODUCT(--(Workflow!G9:G305="New
Facility"),--(Workflow!S9:S305="Yes"), --(Workflow!U9:U3050),Workflow!U9:U305)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Andrew" wrote in message
...
I created a formula in Excel 2007:

=COUNTIFS(Workflow!G9:G305,"New Facility",Workflow!S9:S305,"Yes") and
=SUMIFS(Workflow!U9:U305,Workflow!G9:G305,"New
Facility",Workflow!S9:S305,"Yes",Workflow!U9:U305, "0")

but it will appear that "COUNTIFS" and "SUMIFS" are not available in excel
2003.

Do you perhaps know which alternatives i can use?

--
Andrew