Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need to create an array formula combined with a countif
I need to only count the "C" in one array, but only if there is a C1 in the
adject cell |
#2
|
|||
|
|||
I need to create an array formula combined with a countif
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 |
#3
|
|||
|
|||
I need to create an array formula combined with a countif
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 |
#4
|
|||
|
|||
I need to create an array formula combined with a countif
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 |
#5
|
|||
|
|||
I need to create an array formula combined with a countif
I will give it a try, I just posted this same question but a lot more
detailed, maybe it will make more sense. I am not familiar with this type of formula, so I am not sure it will work. Please read my other posting. "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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array | Excel Worksheet Functions | |||
Trouble shooting#NA error in Array formula | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
What instead of an array formula? | Excel Discussion (Misc queries) |