| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Count values inside a cell when refered elsewhere?
Hi, Hope you can help..... A1 - A10 contains: A,A,B,C,B,B,C,A,A,C B1 - B10 contains: 10,5,10,3,5,5,10,7,5,10 How can I add up the contents of the cells that relate to 'A' i.e. answer should be 27 (10+5+7+5) I've tried - SUMIF, IF(SUM), SUM(COUNTIF) and I still can't get it to look at A1-A10 and then add up those in B1-B10 that relate. Thanx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Table Lookup formula where 2 known values are inside array | New Users to Excel | |||
| How to count the number of 'values' in a cell | Excel Worksheet Functions | |||
| Count values in a cell | Excel Worksheet Functions | |||
| Count number of values in a cell | Excel Worksheet Functions | |||
| Count values bigger than cell | Excel Discussion (Misc queries) | |||
Threaded Mode
