| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
countif formula
I am having trouble coming up with a countif formula for dates. i need it to
count anything submitted with a particular month, and also then a formula to count the next column. example june 7 yes june 14 no May 21 yes June=2 June No= 1 Does that make sense? |
|
#2
|
|||
|
|||
|
=SUMPRODUCT(--MONTH(A2:A20)=6))
=SUMPRODUCT(--(MONTH(A2:A20)=6),--(B2:B20="No")) -- HTH Bob Phillips "Todd Nelson" wrote in message ... I am having trouble coming up with a countif formula for dates. i need it to count anything submitted with a particular month, and also then a formula to count the next column. example june 7 yes june 14 no May 21 yes June=2 June No= 1 Does that make sense? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| COUNTIF formula problems | Excel Discussion (Misc queries) | |||
| Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
| IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Hybrid Mode
