View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hooper222
 
Posts: n/a
Default =IF(Range=Range, Range)


I am trying to use Excel to check if column B = column A then = c.
Which works fine for one row, but I would like to sum the results.


x x 1 y 1 y 6
x x 2 y 1 y 5
x x 3 y 6 y 4
x x 4 y 3 x 3
x x 5 y 9 x 2
x x 6 y 1 y 1
x x 7 y 8 y 0
x x 8 y 2 x 9
x x 9 y 1 x 8
= ?? = ?? = ??


Thanks,

Rob


--
hooper222
------------------------------------------------------------------------
hooper222's Profile: http://www.excelforum.com/member.php...o&userid=30108
View this thread: http://www.excelforum.com/showthread...hreadid=497943