Summing N/A's
 

Thanks Tom!

And if the cells are non adjacent...?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Summing N/A's
 

That would be harder. Is there a pattern involved?

If it is blocks of cells but no pattern, you could always use the summation
sign (+) linking separate sumif formulas.

--
Regards,
Tom Ogilvy

"Darin Kramer" wrote in message
...
Thanks Tom!

And if the cells are non adjacent...?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!