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