sum cells ignoring blanks and text
How can I sum cells but ingnore any blank cells or cells containing text without giving a 0 response.
In the example attached I want to add the cells from column A and B to create C. Cells in row 6 contain blanks. A simple =SUM(A1:B1) copied down column C gives a 0 response in C5 and C6. Cheers
Last edited by mickurje; 07-04-2010 at 02:53 PM. Reason: did not make sense
This maybe:
=IF(AND(ISNUMBER(A1), ISNUMBER(B1)), SUM(A1:B1), "")
Last edited by zbor; 07-04-2010 at 02:53 PM.
Never use Merged Cells in Excel
Worked a treat. Thanks. Homework done just in time for top gear.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks