Over the years I have gotten into the habbit of using the redundant
parenthasis. I am relieved to hear that there has not been some sort of
unknown error happeing because of this.

--
Thanks
Shawn


"KL" wrote:

Hi Shawn,

The result will be the same, but the parenthesis around C1:C100 in the
second formula are simply redundant :-)

Regards,
KL


"Shawn" wrote in message
...
Instead of =SUMPRODUCT((A1:A100=3)*(B1:B100=6)*C1:C100)


what would be the difference if you used:


=SUMPRODUCT((A1:A100=3)*(B1:B100=6)*(C1:C100))


--
Thanks
Shawn


"Chip Pearson" wrote:

Teresa,

Try the following. Adjust the ranges to suit your needs.

=SUMPRODUCT((A1:A100=3)*(B1:B100=6)*C1:C100)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"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