Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Here's my spreadsheet:
Column A Column B N Red N Blue N Red Orange N Blue Red N Yellow Here's what I'd like to accomplish: If there's an "N" in column A, then count the number of times "Red" and "Blue" appear in column B. If there is no "N" in column A, do not count it. In the above example, I'd expect the formula to return a result of four. Thanks for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Question | Excel Worksheet Functions | |||
Formula question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Discussion (Misc queries) | |||
formula question | Excel Discussion (Misc queries) |