spreadsheet
 

hey i need to know how to make a letter(checkmark) appear as a dollar amount
when going into a total

spreadsheet
 

What? That doesn't make much sense... If I understand you correctly, just
format the cell as currency or accounting, noting the dollar sign.

"stacy" wrote:

hey i need to know how to make a letter(checkmark) appear as a dollar amount
when going into a total

spreadsheet
 

Stacy,

Array enter (enter using Ctrl-Shift-Enter) a formula like

=SUM(EXACT(A1:A1000,B1)*AMOUNT)

where B1 contains a checkmark (format it with the same font), and AMOUNT has been replace with the
value of each checkmark....

HTH,
Bernie
MS Excel MVP


"stacy" wrote in message
...
hey i need to know how to make a letter(checkmark) appear as a dollar amount
when going into a total