Used the formula as written, results in #VALUE!.

I believe my ranges are okay, since I have summed the returns based on
reasons only; I want to breakdown the results further by Whs.

Thank you.

"Jacob Skaria" wrote:

=SUMPRODUCT((Whs=1),(Reasons=1),(Returns))
--
If this post helps click Yes
---------------
Jacob Skaria


"Alex Mackenzie" wrote:

I admit I do not fully understand SUMPRODUCT; I am trying to follow the
variious samples I have found.

Data:

Whs Reasons Returns
1 1 2
10 DF 1
1 2 1

I want to sum the number of Returns when Whs=1 and Reasons=1, where Whs,
Reasons and Returns are all named ranges.

I have "=SUMPRODUCT((Whs=1)*AND(Reasons=1)*(Returns)) but the result is 0
rahter than 2.

Any help would be greatly appreciated.

Thank you.