Normally entered:

=SUM(INDEX((A1:A10="x")*(B1:B10=1),,1))

--
Biff
Microsoft Excel MVP


"Chris" wrote in message
...
On Mar 17, 2:47 pm, Dave Peterson wrote:
You don't need to array enter this formula.

In xl2007, there are =sumifs() and =countifs()

Chris wrote:

Is there any way to replicate this formula with countif or sumif and
not using the array (ctr shift enter) function?

=SUMPRODUCT((A19:A357=A7)*(Y19:Y357=1))

--

Dave Peterson

Sorry, meant to say COUNTIFS and SUMIFS aren't supported by my other
program, are there any other workarounds?