No, ignore that last comment - I need some caffeine !! <bg

Pete

"Pete_UK" wrote in message
...
You're welcome. If you want to sum where the cells in row 1 are empty
(same as "not W" in this case), you would use:

=SUMIF(1:1,"<",4:4)

Pete

On Aug 27, 4:19 pm, Lee Ann wrote:
Okay, I see what he was writing. That will take care of the Non W columns.
I tried using a 0, in lieu of the "W" and that seemed to pick up the
totals
in the non W columns. For some reason, however it would not read the same
rows as the formula to calculate the Ws. This other one works, though.

Thank you both for your responses. Such a simple formula to save alot of
folks some major headaches (and mathematical errors).