The formula looks good but do not work

=SUM(IF(($E$1:$E$1600=N2)*($K$1:$K$1600100)*($K$1 :$K$1600<300),$K$1:$K$1600,))

1600 is the maximum of rows

Where is I do wrong??

--
Just a regular user


"Jarek Kujawa" wrote:

try:

=SUM(IF(($E$1:$E$65536=N2)*($K$1:$K$65536100)*($K $1:$K$65536<300),
$K1$:$K$65536,)))

this is an array formula so CTRL+SHIFT+ENTER it instead of using
simply ENTER