| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count rows where a specific value appears in any of 4 columns
You are welcome.
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "LisaM" wrote in message ... Hi Ashish, Thank you for your help. This does this job! Lisa "Ashish Mathur" wrote: Hi, In column E, use the formula COUNTIF(A2:D2,1)0 and copy all the way down to row 5807. Now in a spare cell, use the formula =COUNTIF(E2:E5807,TRUE) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count the number of times a specific date appears in a range of ce | Excel Worksheet Functions | |||
| count how many rows a word appears in | Excel Worksheet Functions | |||
| Count the times a specific character appears in a cell | Excel Worksheet Functions | |||
| Count the number of times specific text appears in a column | Excel Worksheet Functions | |||
| count the number of times a specific word appears in a column | Excel Worksheet Functions | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
