Quote:
Originally Posted by PDX_Jim
That is what I was looking for. I wasn't familiar with the sumproduct formula. Thanks!
One question though, in the formula =SUMPRODUCT(--(DATA!$A$2:$A$38=$A2)*(DATA!$B$2:$B$38=B$1),DATA!$ C$2:$C$38)
what are the "--" before (DATA!$A$@...) for?
Thanks,
Jim
|
Hi Jim,
This link will explain it far better than I would...
www.xldynamic.com/source/xld.SUMPRODUCT.html