| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
COUNTIF or SUMIF Problem
Hi folks:
I have a Bill-of-Materials where the parts used in a product are referenced like C11, R22, etc. The contents of C2 a C13,C16,C18,C19,C23 To get a quantity of the parts used of each type, is it possible to count the occurences of "C" (or R, or anything else) ? I've tried =COUNTIFSheet1!,"*C*" and variants Would appriciate any help - Many thanks Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forget SUMIF, COUNTIF and VLOOKUP | Excel Worksheet Functions | |||
| using sumif & countif to sort multiple cells | Excel Worksheet Functions | |||
| SUMIF problem | Excel Worksheet Functions | |||
| Modify SUMIF and COUNTIF to work with SUBTOTALS | Excel Worksheet Functions | |||
| Countif, Sumif, If - help! | Excel Worksheet Functions | |||
Threaded Mode
