| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting multiple cell values! Please help!
Hello everyone,
In cell C1 of sheet 2, I need the count all "x" entries from cel A1:A10 in sheet 1. _How_do_I_achieve_this?_ Thanks in advcance fo your help! Regards, Kim-An -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting multiple cell values! Please help!
Try this
=COUNTIF(Sheet1!A1:A10,"x") -- Regards Ron de Bruin http://www.rondebruin.nl "Kim-Anh Tran " wrote in message ... Hello everyone, In cell C1 of sheet 2, I need the count all "x" entries from cell A1:A10 in sheet 1. _How_do_I_achieve_this?_ Thanks in advcance fo your help! Regards, Kim-Anh --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting multiple cell values! Please help!
Your help is well appreciated!
Have a wonderful day! Regards, Kim-An -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting values based on multiple conditions | Excel Worksheet Functions | |||
| Counting multiple values within single cells | Excel Worksheet Functions | |||
| Counting values in multiple columns | Excel Discussion (Misc queries) | |||
| counting rows with same values for multiple values | New Users to Excel | |||
| Counting Multiple Values In A Cell | Excel Worksheet Functions | |||
![Kim-Anh Tran[_18_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
