lifeson
10-14-2008, 10:03 AM
CAn someone hlep me with a sumproduct across 4 columns
I have got to the following but my head hurts:(
Where:
id is a string variable
chkDate is Long
With ws
hrsUsedInYr = WorksheetFunction.SumProduct(--("A2:A100" = id), --("B2:B100" = "H"), --("C2:C100" >=chkDate),"E2:E100")
end with
Thanks
I have got to the following but my head hurts:(
Where:
id is a string variable
chkDate is Long
With ws
hrsUsedInYr = WorksheetFunction.SumProduct(--("A2:A100" = id), --("B2:B100" = "H"), --("C2:C100" >=chkDate),"E2:E100")
end with
Thanks