| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif with multiple criteria
I'd like to be able to count the number of "Y" in column H where the values
in column D are equal to 12, 21, 60 or 23. Any ideas would be appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countif with multiple criteria
Try :
=SUMPRODUCT(((D1:D7=12)+(D1:D7=21)+(D1:D7=23)+(D1: D7=60))*(F1:F7="y")) HTH Daniel I'd like to be able to count the number of "Y" in column H where the values in column D are equal to 12, 21, 60 or 23. Any ideas would be appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countif with multiple criteria
=SUMPRODUCT((H2:H20="Y")*(D2:D20={10,21,23,60}))
-- __________________________________ HTH Bob "Sarah (OGI)" wrote in message ... I'd like to be able to count the number of "Y" in column H where the values in column D are equal to 12, 21, 60 or 23. Any ideas would be appreciated. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countif with multiple criteria
oops. I meant
=SUMPRODUCT((H2:H20="Y")*(D2:D20={12,21,23,60})) -- __________________________________ HTH Bob "Sarah (OGI)" wrote in message ... I'd like to be able to count the number of "Y" in column H where the values in column D are equal to 12, 21, 60 or 23. Any ideas would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple criteria for Countif | Excel Discussion (Misc queries) | |||
| Nesting COUNTIF for multiple criteria in multiple columns | Excel Worksheet Functions | |||
| COUNTIF MULTIPLE CRITERIA | Excel Discussion (Misc queries) | |||
| COUNTIF with multiple criteria? | Excel Worksheet Functions | |||
| Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
