Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() ![]() times a condition is meet in two cells. IF A1=RED AND B1=YES ie. A B 1 RED YES 2 BLUE NO 3 RED NO 4 BLUE NO 5 RED YES RESULT WOULD BE RED YES=2 RED NO=1 Thanks Rik -- Rikuk ------------------------------------------------------------------------ Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559 View this thread: http://www.excelforum.com/showthread...hreadid=502164 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Countif Formula /Sort Bug??? | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF help | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions |