G
Guest
Guest
I'm slowly making progress with arrays, but don't have this one under my belt yet.
I want to sum a column based on three criteria and an array will do the job.
The problem is that I need one of the criteria to be the value in a cell (a variable).
Using one variable,
entered as an array, this works:
{=sum((A2:A100="887")*(F2:F100)+0}
where column A is the criterion and column F is the value to be summed.
Instead of hard coding the "887" I need the statement to read the value in another cell, let's say in H1.
I've tried ...(A2:A100=H1) ...
and ... (A2:A100="H1") ...
but neither work.
How do I use a variable criterion?
Thanks!
I want to sum a column based on three criteria and an array will do the job.
The problem is that I need one of the criteria to be the value in a cell (a variable).
Using one variable,
entered as an array, this works:
{=sum((A2:A100="887")*(F2:F100)+0}
where column A is the criterion and column F is the value to be summed.
Instead of hard coding the "887" I need the statement to read the value in another cell, let's say in H1.
I've tried ...(A2:A100=H1) ...
and ... (A2:A100="H1") ...
but neither work.
How do I use a variable criterion?
Thanks!