Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
I need to the count the number of times a value, represent in column B1 in
sheet 1 appears in the range H1:h15000 in another worksheet Thanks ce |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
Hi, Curtis.
Your question isn't too clear, but it sounds like you can use COUNTIF, since you only have 1 criteria: =COUNTIF('Sheet2'!H1:H15000,'Sheet1'!B1) If that is not what you are looking for, please provide better details. Jason "Curtis" wrote: I need to the count the number of times a value, represent in column B1 in sheet 1 appears in the range H1:h15000 in another worksheet Thanks ce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
SUMPRODUCT | Excel Discussion (Misc queries) | |||
SUMPRODUCT | Excel Worksheet Functions | |||
Using SumProduct in VB | Excel Discussion (Misc queries) | |||
SumProduct? | Excel Worksheet Functions |