| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula format for Count or Countif funtion with two criterias
What would be the formula specifics when I want to use the count or countif
funtion with two criteria. Example: Count A1:A5 and c1:c5 countif A1:A5 equals f and D1:D5 equals h Countif A1:A5 equals f and count D1:D5 |
|
#2
|
|||
|
|||
|
=COUNT(A1:A5)+COUNT(C1:C5)
=SUMPRODUCT(--(A1:A5="f"),--(D1:D5="h")) =SUMPRODUCT(--(A1:A5="f"),--(D1:D5<"")) -- Regards, Dave "Debi" wrote: What would be the formula specifics when I want to use the count or countif funtion with two criteria. Example: Count A1:A5 and c1:c5 countif A1:A5 equals f and D1:D5 equals h Countif A1:A5 equals f and count D1:D5 |
|
#3
|
|||
|
|||
|
For COUNT, you can use a single formula, as it accepts multiple ranges, i.e.
=COUNT(A1:A5,C1:C5) On Mon, 26 Sep 2005 11:01:04 -0700, "Debi" wrote: What would be the formula specifics when I want to use the count or countif funtion with two criteria. Example: Count A1:A5 and c1:c5 countif A1:A5 equals f and D1:D5 equals h Countif A1:A5 equals f and count D1:D5 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif formula | Excel Discussion (Misc queries) | |||
| Countif Formula with changing criteria | Excel Discussion (Misc queries) | |||
| how can i create a formula or format the cells so the answer is a. | Excel Discussion (Misc queries) | |||
| formula based on format | Excel Discussion (Misc queries) | |||
| How do I format a character from a result of formula in excel? | Excel Discussion (Misc queries) | |||
Linear Mode
