| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF() With multiple ranges and variables
The function I am looking for is something that will simply look at 2
ranges (euqaly large) and only count them if they meet 2 criteria on the same row EX: A B 1 1 1 2 1 3 2 1 2 2 2 3 So what I am sorta looking for is something that would count the instances where A = 1 and B 1. I can't figgure out a propper function for this. Any help would be appreciated. AlexV |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF() With multiple ranges and variables
=SUMPRODUCT((A1:A1000=1)*(B1:B10001))
HTH -- AP "Thansal" a écrit dans le message de news: ... The function I am looking for is something that will simply look at 2 ranges (euqaly large) and only count them if they meet 2 criteria on the same row EX: A B 1 1 1 2 1 3 2 1 2 2 2 3 So what I am sorta looking for is something that would count the instances where A = 1 and B 1. I can't figgure out a propper function for this. Any help would be appreciated. AlexV |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF() With multiple ranges and variables
=SUMPRODUCT(--(A1:A6=1),--(B1:B61))
"Thansal" wrote: The function I am looking for is something that will simply look at 2 ranges (euqaly large) and only count them if they meet 2 criteria on the same row EX: A B 1 1 1 2 1 3 2 1 2 2 2 3 So what I am sorta looking for is something that would count the instances where A = 1 and B 1. I can't figgure out a propper function for this. Any help would be appreciated. AlexV |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF() With multiple ranges and variables
Thank you all.
It took me a long time, but that was b/c I had an error in my data that I had not caught. Sloth wrote: =SUMPRODUCT(--(A1:A6=1),--(B1:B61)) "Thansal" wrote: The function I am looking for is something that will simply look at 2 ranges (euqaly large) and only count them if they meet 2 criteria on the same row EX: A B 1 1 1 2 1 3 2 1 2 2 2 3 So what I am sorta looking for is something that would count the instances where A = 1 and B 1. I can't figgure out a propper function for this. Any help would be appreciated. AlexV |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using variables in Chart Ranges | Charts and Charting in Excel | |||
| Cell Variables and Ranges | Excel Discussion (Misc queries) | |||
| linest won't accept multiple reference ranges | Excel Worksheet Functions | |||
| How do you populate the X variables in Regression analysis for mo. | Excel Worksheet Functions | |||
| How do I automatically plot different ranges of data in different. | Charts and Charting in Excel | |||
Linear Mode
