On Mar 17, 3:42*pm, "T. Valko" wrote:
Any possible SUMIF or COUNTIF solutions?

No

--
Biff
Microsoft Excel MVP

"Chris" wrote in message

...
On Mar 17, 3:16 pm, "T. Valko" wrote:





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?

It looks like INDEX is not supported either. Any possible SUMIF or
COUNTIF solutions?- Hide quoted text -

- Show quoted text -

ok, thanks for your help.