I have a large worksheet and I'm trying to pull some specific information
out of it, and I'm not getting the numbers I expected- so I think there is
something wrong with my syntax. I'm hoping that someone can help point out
my error. As the actual references are quite long, I've shortened them here
to just show the logic, to determine if the logic itself if bad

={sum((if(A1:A30000 =
D7,1,0))*(if(B1:B3000038717,1,0))*(if(C1:C30000<E 1:E30000,1,0)))}

I had expected this to calculate each if statement to a 1 or 0, them
multiply the outcome of those three if statements (so I'd get a value of 1
if all were true, or zero if any were false), then sum the number of lines
where all three conditions were true.

The actual number I'm getting is somewhere between 2x and 4x the number I'd
actually expect based on the data, so either my logic is bad, or I have some
other error. If no-one points out any errors in the above logic (multiplying
and summing the if statements) then I'll re-post with the actual (longhand)
formula to see if there is some other problem.

Many thanks,
Keith

--
The enclosed questions or comments are entirely mine and don't represent the
thoughts, views, or policy of my employer. Any errors or omissions are my
own.