I am using Excel 2010 and trying to SUM a column of text strings to display a total. I have a text string in cells D3:D44 and want to assign a value of (1) any time there is text entered into one of those cells. Then I'd like to SUM cells D3:D44 to display the total. Please see attached.
Job Man Power.jpg
Try COUNTIF:
e.g =COUNTIF(D3:D44,"<>")
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi getblended and welcome to the forum,
How about trying
=COUNTA(D3:D44)-COUNT(D3:D44)
which will count all cells that have stuff in them minus ones that have numbers in them.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
In case D3:D44 is populated by formulas that return an empty string
try this regular formula:
Does that help?
Please Login or Register to view this content.
Last edited by Ron Coderre; 01-12-2012 at 11:45 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks