Oops, forgot to actually sum:
=SUMPRODUCT((JAN_05'!$C$2:$C$65536=$A5)*(JAN_05'!J $2:$J$655360)*JAN_05'!J$2:$J$65536)
HTH,
Bernie
MS Excel MVP
"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Curtis,
=SUMPRODUCT((JAN_05'!$C$2:$C$65536=$A5)*(JAN_05'!J $2:$J$655360))
HTH,
Bernie
MS Excel MVP
"Curtis" wrote in message
...
I am currently using the formulae to clcualte the sum for $A5
=SUMIF(JAN_05'!$C$2:$C$65536,$A5,JAN_05'!J$2:$J$65 536)
I would to modify this so it leaves out all numbers less than 0
Thanks
|