View Single Post
  #8   Report Post  
CarFreek
 
Posts: n/a
Default


I also tried another function to do the same job as the SUMIF I have
been asking questions on. I tried an HLOOKUP with a SUM at the
beginning. I couldnt get that to work either. Any ideas?


=SUM(I5: (=HLOOKUP($F$2, I4:BJ230,H5,TRUE)

This is the other way I tried to do it but it wouldnt work either.

Eddie


--
CarFreek
------------------------------------------------------------------------
CarFreek's Profile: http://www.excelforum.com/member.php...o&userid=24334
View this thread: http://www.excelforum.com/showthread...hreadid=379433