| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF with 2 conditions/columns
Hi,
Column A = Date, Column B = Day of Week , Column C= Weather (Sunny, Rainy etc) I know I can use COUNTIF to count the number of wednesdays in B, or the number of Rainy's in C. I'm trying to count the number of Rainy Wednesdays. COUNTIF seems the way to go, but clearly isn't. Help appreciated. -- Rich http://www.richdavies.com/online-mor...calculator.htm http://www.richdavies.com/saving-money.htm ** Posted from http://www.teranews.com ** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
| Countif depending on the conditions across multiple columns | Excel Worksheet Functions | |||
| Using countif with 2 conditions | Excel Worksheet Functions | |||
| COUNTIF 2 conditions | Excel Worksheet Functions | |||
| COUNTIF for 2 conditions | Excel Worksheet Functions | |||
![Rich[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
