Value

S

Susan

Hello,



I would appreciate some help with the following problem in Excel, what I
want to do is to type a word in a cell which is associated with a number,
and that number is then added to a total column.



For example, if I type in 'late' a value of 12 is added to the totals
column.



I would be very grateful for some advice.



Love,



Susan
 
N

Norman Harker

Hi Susan!

If you only want this to happen once you can adapt JE's approach.

=IF(COUNTIF(A1:L1,"late")>0,12,0)



--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top