| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct help
ill make that change.
thanks! "Dave Peterson" wrote: You're formula looks ok to me. Are you sure that you're not miscounting? If you have your data filtered, maybe it's in one of the hidden rows??? Any chance you're including a row with June of a different year? =SUMPRODUCT(--(V2:V999="CUSTOMER"),--(text(B2:B999,"yyyymm")="200606")) Would check for June of this year. scott wrote: my sumproduct statement is adding 1 to the end result for some reason. does anyone know how this might happen? =SUMPRODUCT(--(V2:V999="CUSTOMER"),--(MONTH(B2:B999)=6)) I am trying to count how many times "customer" is selected from a drop down list in the month of June. Thanks, Scott -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct | Excel Worksheet Functions | |||
| sumproduct causing memory errors? | Excel Worksheet Functions | |||
| Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Hybrid Mode
