| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I set up an array using countif for 2 separate arguments.
I want the cell to count, but only if 2 separate arguments are met. Can that
be done? |
|
#2
|
|||
|
|||
|
Care to provide a bit more info, preferably by means of a tiny sample
along with the expected count? crich wrote: I want the cell to count, but only if 2 separate arguments are met. Can that be done? |
|
#3
|
|||
|
|||
|
Hi,
Name Dept Grade Sam A 1 Patrick A 2 David A 1 If you want to count the number pf people who are in Department A and have grade 1, enter the following formula Array enter (Ctrl+Shift+Enter) the following formula in cell E10 SUM(IF((D6:D8="A")*(E6:E8=1),1,0)) Regards, "crich" wrote: I want the cell to count, but only if 2 separate arguments are met. Can that be done? |
|
#4
|
|||
|
|||
|
I tried this, but the formula didn't work. It just returns a value of 0.
BUT, I really think we are getting close. Any more ideas? Thanks. "Ashish Mathur" wrote: Hi, Name Dept Grade Sam A 1 Patrick A 2 David A 1 If you want to count the number pf people who are in Department A and have grade 1, enter the following formula Array enter (Ctrl+Shift+Enter) the following formula in cell E10 SUM(IF((D6:D8="A")*(E6:E8=1),1,0)) Regards, "crich" wrote: I want the cell to count, but only if 2 separate arguments are met. Can that be done? |
|
#5
|
|||
|
|||
|
The example is as Ashish wrote below, but the formula didn't work. It just
returns a value of 0. BUT, I really think we are getting close. Thanks. "Aladin Akyurek" wrote: Care to provide a bit more info, preferably by means of a tiny sample along with the expected count? crich wrote: I want the cell to count, but only if 2 separate arguments are met. Can that be done? |
|
#6
|
|||
|
|||
|
The suggested formula should yield the count you need. Note that the
formula must be confirmed with control+shift+enter, not just with enter. crich wrote: The example is as Ashish wrote below, but the formula didn't work. It just returns a value of 0. BUT, I really think we are getting close. Thanks. "Aladin Akyurek" wrote: Care to provide a bit more info, preferably by means of a tiny sample along with the expected count? crich wrote: I want the cell to count, but only if 2 separate arguments are met. Can that be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where is the bug in my array? | Excel Discussion (Misc queries) | |||
| countif array formula | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
| Countif - Countif | Excel Worksheet Functions | |||
Linear Mode
