A "Strikethrough" Condition

  • Thread starter Thread starter JoeC
  • Start date Start date
J

JoeC

I would like to sum a col of figures only if they have a
strikethrough them. How would i write the condition in a
formula?
Thanks
JoeC
 
Hi
this would require VBA. Not possible with worksheet functions alone.
Are you willing to use VBA?
 
Yes, would like to try.
Thanks
JoeC
-----Original Message-----
Hi
this would require VBA. Not possible with worksheet functions alone.
Are you willing to use VBA?

--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Frank: strikethrough condition 1
countif strikethrough 1
strikethrough condition 1
Need to remove text with strikethrough - Excel 2007 6
CONDITIONAL FORMATTING BETWEEN SHEETS 1
Conditionally formatting numeric data and text differently 1
conditional formatting based on relative cell value 2
Formatting the color of a range of cells based on the value of one cell 3

Back
Top