| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for counting cells with value 'x' provided Col U = 'y'
Hi guys,
Need some help with a formula please. Have tried myself and know that the answer is straightforward but going through a mental block! Col Q Col R A01 58 A01 62 P02 62 Both columns data starts in cell 14 and runs down to cell 10000. I need to count the entries in Column Q that = A01 ONLY IF Col R = 62. Then do the same for Q = A01 ONLY IF R = 58, and so on. The worksheet is a year-to-date file and will be updated weekly with many entries in both columns with varying values. Many thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting blank cells in a formula | Excel Worksheet Functions | |||
| Confirmation ID provided? | New Users to Excel | |||
| Formula for counting number of cells | Excel Discussion (Misc queries) | |||
| Counting cells with formula CF (not value CF) | Excel Worksheet Functions | |||
| How do I write a formula to color code based on dates provided or. | Excel Worksheet Functions | |||
![J.Scargill[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
