| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count cells with specific value?
Hello every one,
I am still trying to wrap my mind around array formula, this is my challenge now. How do I count cells with specific value? Example: ___A____B__C__D__E__F__E 1_ONE___X_____Y_____Z___ 2_TWO_____Y______Z__Z__ 3_TWO___Z_____Y____X__Z 4_ONE___Y__Y_______Z___X 5_TWO_________X_______X 6_TWO_____X______Y____Y 7_ONE___X______________X 8_ONE_____X____Z__X____Y In a column A1:A8 I got some ONEs and TWOs, how do I count, how many Y there are in ONE rows, range B1:E8. The way I see it, it is calling for array formula. Please help! Thank you, Guntars |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count cells containing specific text | Excel Discussion (Misc queries) | |||
| If two cells have specific text to count as 1 | Excel Worksheet Functions | |||
| How do I count cells that contain one of several specific numbers? | Excel Worksheet Functions | |||
| Count cells with specific values in the cells next to them? | Excel Worksheet Functions | |||
| Need formula to count specific cells in a row | Excel Worksheet Functions | |||
Threaded Mode
