sumproduct?
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
|