sumproduct formula work around
Could you use a helper column? Say, in Z19 enter the formula:
=IF(AND(A19=$A$7,Y19=1),1,0)
Copy down through through Z357. Then, do a =SUM(Z19:Z357).
HTH
Elkar
"Chris" wrote:
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
COUNTIF formula works but isn't supported by my other program. Are
there any other workarounds?
|