| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Sumproduct
Glad I could help
"gjameson via OfficeKB.com" wrote: Outstanding Mike. Thank you, it works great. Also thanks to the other that answered as well. Gerald Mike H wrote: Try =SUMPRODUCT(--(MONTH(Calls!A8:A500)=1),--(YEAR(Calls!A8:A500)=2008),--(Calls!G8:G500="DP")) Mike I just want to count the occurrences for any given month in the year. How would you set [quoted text clipped - 6 lines] Gerald -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200812/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif - Sumproduct | Excel Worksheet Functions | |||
| COUNTIF or SUMPRODUCT | Excel Discussion (Misc queries) | |||
| SumProduct and Countif | Excel Worksheet Functions | |||
| Sumproduct or Countif | Excel Worksheet Functions | |||
| SUMPRODUCT & COUNTIF | Excel Worksheet Functions | |||
Hybrid Mode
