I'm not sure what you are trying to do. I think the following does what you
want:
Function car(dnm As String) As Date
Dim table(10) As Date
table(1) = #12/19/2008#
For i = 2 To 9
table(i) = table(1) + i - 1
Next i
table(10) = table(1) + 11
If dnm = "K1" Then
YOu have to just extent the formula of Sumproduct.
Please send me the sample worksheet with the requirement. I will do it for
you!
Regards,
Andy
On Fri, Dec 12, 2008 at 4:33 AM, Chris Salcedo wrote:
>
> I need to count data based on 3 criteria.. I have this working for 2
> but now need a third.
Hi Chris,
Try this array Formula and let me know if it work out for you..
=SUM((MONTH($B$1:$B$19)=MONTH(AA1)) * ($C$1:$C$19="P"))
Remember to add this formula using Ctrl+Shift+Enter(Array Formula).
Cheers,
Lohith
On Dec 12, 2:33 am, Chris Salcedo wrote:
> I need to count data based on 3 cr
Hi Tom,
Thanks for the help. I've a Query for you.
While executing it.
Combo Box is working. When i select a Date from Combo Box and When I
hit "OK"
"Run Time Error 1004" is displayed with a msg
*"Unable to get the Vlook up properties of the work sheet function
class" *
On Fri
