Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Countif to use like sumif
Hi all,
Need some help with this problem that has been bugging me. I have the following data ColA ColB ColC 1999 100 150 1999 0 75 2000 150 200 2001 200 250 2001 0 100 2001 0 100 I need to look down column A and return the number of data points 0 (Count) in column B & C i.e. 1999 1 2 2000 1 1 2001 1 3 If countif worked like sumif I would do something like countif(ColA,"2001",ColB)=1, countif(ColA,"2001",ColC)=3. Unfortunately countif does not work like this so I need another way to get a formula to count the number of data points in the columns B&C that meet the conditions in column A. Could I program a similar function in VBA. Any help will be seriously appreciated. Thanks Pantelis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF or COUNTIF | Excel Worksheet Functions | |||
countif - sumif | Excel Discussion (Misc queries) | |||
COUNTIF?? SUMIF?? | Excel Discussion (Misc queries) | |||
SUMIF vs COUNTIF | Excel Discussion (Misc queries) | |||
Countif, Sumif | Excel Worksheet Functions |