Thank you for the insight! The numbers were struck through bcz the policies
were cancelled and did not need to be included in the total revenue for that
year.

Ron, your explaination makes total sense and I've added it to my
spreadsheets. Thanks to all for the quick response!



"Ron Coderre" wrote:

You're working against Excel, instead of with it.....Excel's native functions
can't "see" cell formats.

Instead, flag the numbers with a "helper" column where you put an "x" to
mark the values to skip. Then you can just use the SUMIF function.

Example:
To add only the items in A1:A10 where the corresponding itmes in Col_B do
NOT equal "x"
=SUMIF(B1:B10,"<x",A1:A10)

(Otherwise, you'll need a custom VBA function to do what you're asking for.)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"baklava" wrote:

I have a column of numbers that I want to total; however, some of the rows
have the number struck through - these are the numbers I DO NOT want to
include in the total.

=sumif(a1:a20, and here is where I get stuck. How do I tell excel to sum
all the numbers in the range except those that have strike through.

Or is there a different formula to use?

Thanx!