Range? M1:Z1
is it
=IF(F1=SUM(M1:Z1),"yes","no")
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"nastech" wrote in message
...
Hi, can not remember how to see if 1 cell, is equal to same quantity in
range
of other cells. Tried / to find: (thanks)
=F1=M1:Z1 getting ref error
|