Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Hi All Ok, what I would like to do is use multiple countif functions in 1 cell. I have a list of values in column C, and a corresponding tolerance in column B. So basically, it's something like if C2 B2, then count as 1, if C3 < B3, then count as 1, if C4 = B4, then count as 1, if C5 B5, then count as 1, etc. I want to be able to count the number of cells in column C that meet the criteria against their targets in column B. Is this possible? I hope this makes sense Much appreciated Oz -- ozcank ------------------------------------------------------------------------ ozcank's Profile: http://www.excelforum.com/member.php...fo&userid=5328 View this thread: http://www.excelforum.com/showthread...hreadid=484779 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
COUNTIFs with multiple criteria | Excel Discussion (Misc queries) | |||
view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) |