I need to create an array formula combined with a countif
You are the bomb! IT WORKS!!!! I have never known anything about t he '--'
before and I am not clear how it works, but it did - perfectly!
"Biff" wrote:
Hi!
Each element of the arrays:
(A1:A100="C")
(B1:B100="C1")
return either TRUE or FALSE
"--" converts these to 1's and 0's which Sumproduct can then process.
Biff
"Rochelle B" wrote in message
...
I am not understanding the (--, please forgive me if this is a stupid
question, it's late and I am tired and need to finish this for a report in
the morning.
Thanks
"Biff" wrote:
Hi!
=SUMPRODUCT(--(A1:A100="C"),--(B1:B100="C1"))
Biff
"Rochelle B" wrote in message
...
I need to only count the "C" in one array, but only if there is a C1 in
the
adject cell
|