If
If in rows 5 through 16 I have either entered nothing or an X, Using the if
command how would I in row 17 add every cell that I have entered nothing? Thanks Kevin |
pls do NOT multipost. Most of us read em all.
BTW pls try to use more meaningful subject lines. -- Don Guillett SalesAid Software "Kevin" wrote in message ... If in rows 5 through 16 I have either entered nothing or an X, Using the if command how would I in row 17 add every cell that I have entered nothing? Thanks Kevin |
=countblank(A4:A17)
-- Regards, Tom Ogilvy "Kevin" wrote in message ... If in rows 5 through 16 I have either entered nothing or an X, Using the if command how would I in row 17 add every cell that I have entered nothing? Thanks Kevin |
All times are GMT +1. The time now is 09:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com