| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif multiple items
HI,
How do I countif a range where I want it to include more than 1 item. I`m usng the formula : =COUNTIF(AN10:AN89,{"W","SA+","ST","SA"}) This isn`t working, it`s just counting up the first item, i.e. all the "W" entries. How do I get it to count all the SA+, ST and the SA as well? Many thanks. RR1 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif multiple items
Try..
=SUM(COUNTIF(AN10:AN89,{"W","SA+","ST","SA"})) If this post helps click Yes --------------- Jacob Skaria "Romileyrunner1" wrote: HI, How do I countif a range where I want it to include more than 1 item. I`m usng the formula : =COUNTIF(AN10:AN89,{"W","SA+","ST","SA"}) This isn`t working, it`s just counting up the first item, i.e. all the "W" entries. How do I get it to count all the SA+, ST and the SA as well? Many thanks. RR1 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif multiple items
Cheers Jacob. Works great. That was a quick and perfect answer.
Many thanks. RR1 "Jacob Skaria" wrote: Try.. =SUM(COUNTIF(AN10:AN89,{"W","SA+","ST","SA"})) If this post helps click Yes --------------- Jacob Skaria "Romileyrunner1" wrote: HI, How do I countif a range where I want it to include more than 1 item. I`m usng the formula : =COUNTIF(AN10:AN89,{"W","SA+","ST","SA"}) This isn`t working, it`s just counting up the first item, i.e. all the "W" entries. How do I get it to count all the SA+, ST and the SA as well? Many thanks. RR1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF - Summing non-numerical items in cells | Excel Worksheet Functions | |||
| SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter | Excel Worksheet Functions | |||
| How do I create a CountIF statement for a range of items in a list | Excel Worksheet Functions | |||
| Countif count items not in data range | Excel Discussion (Misc queries) | |||
| order form with multiple items and sizes for items | Excel Discussion (Misc queries) | |||
Linear Mode
