Nov 17 2019 03:43 PM
seeking an array formula for the following:
If the file Defense, worksheet Chart1, Column A equals the file PlayerReport, worksheet Opponents, Column A,
and
if the file Defense, worksheet Chart1, Column C equals the file PlayerReport, worksheet Opponents, Column Z
and
if the file Defense, worksheet Chart1, Columns L and M are greater than zero
then
sum all matching rows in the file Defense, worksheet Chart1, Column F
Thank you!
Nov 17 2019 04:21 PM
Nov 17 2019 08:05 PM
Please also attach the PlayerReport file with the Opponents worksheet in it.
Nov 21 2019 07:56 PM
For some unknown reasons, I cannot view your PlayerReport file. Please reduce both files to their barest minimum. Thereafter, attach them again.
Nov 24 2019 08:56 PM
I'm sorry I cannot still view its contents, probably because it contains links I have no access to. Perhaps, you first convert the contents to values before you attach it here.
Nov 25 2019 01:50 PM
Thank you for your patience. I have attached both files in question and have changed all formulas to values. Thanks again.