Sorry, it's a SUMIF function:

xlApp.Application.ActiveCell.Value = SUMIF(E9:E500,"MS",F9:F500)

"Bob Phillips" wrote:

Is that generating an SP formula in a cell, or trying to get a value using
SP? What is the code?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"RAHokie" wrote in message
...
I am using something very similar to this in VBA code building a
spreadsheet
from an Access application. The formula works well in excel but
generates a
syntax error (on the : I think) in VBA. Any suggestions on overcoming
this?

"KL" wrote:

Hi Teresa,

Try this:

=SUMPRODUCT((A2:A1000=3)*(B2:B1000=6)*C2:C1000)

Regards,
KL


"teresa" wrote in message
...
Have 1000 rows of data

col A - I have Job Numbers 1 to 100
col B - I have tasks 1 to 10
col C - I have costs

If I want to know the total cots of task 6 for Job 3....?
I think you can do this via sumproduct?

Many Thanks