Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Countif Function
Counting the number of occurances of a number if a condition is met in an
adjacent column on the same row |
#2
|
|||
|
|||
Hi
if you have two conditions - the number you want to count & the condition in an adjacent cell you'll need to use the SUMPRODUCT function, e.g. =SUMPRODUCT(--(A1:A100=3),--(B1:B100="Red")) check out http://www.xldynamic.com/source/xld.SUMPRODUCT.html for more details on the sumproduct function. Cheers julieD "jrm" wrote in message ... Counting the number of occurances of a number if a condition is met in an adjacent column on the same row |
#3
|
|||
|
|||
That's what it does. Have you looked in HELP index for COUNTIF
-- Don Guillett SalesAid Software "jrm" wrote in message ... Counting the number of occurances of a number if a condition is met in an adjacent column on the same row |
#4
|
|||
|
|||
perfectly described, what is the problem?
-- HTH RP (remove nothere from the email address if mailing direct) "jrm" wrote in message ... Counting the number of occurances of a number if a condition is met in an adjacent column on the same row |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Function | Excel Discussion (Misc queries) | |||
Copy an IF function when Inserting new row | Excel Discussion (Misc queries) | |||
how can i get the slope function to ignore missing data? | Excel Discussion (Misc queries) | |||
Solving for X and Y with a = in the FUNCTION??? | Excel Discussion (Misc queries) | |||
How to call a function from another workbook | Excel Discussion (Misc queries) |