How to SUM only numbers in a range with Text?
Hey,
Thanks for trying. Some cells will be blank as we only enter a value when a
client has been seen. F9 - AD9 are the days of the month and I enter "T 4"
only when the client is seen.
Thanks!
"jhyatt" wrote:
you could do this the only problem i have come up with is if any of the cells
f9:ad9 are blank it = an ERROR
=C9-MID(F9,3,6)-MID(G9,3,6)-MID(H9,3,6)-MID(I9,3,6)-MID(J9,3,6)-MID(K9,3,6)-MID(L9,3,6)-MID(M9,3,6)-MID(N9,3,6)-MID(O9,3,6)-MID(P9,3,6)-MID(Q9,3,6)-MID(R9,3,6)-MID(S9,3,6)-MID(T9,3,6)-MID(U9,3,6)-MID(V9,3,6)-MID(V9,3,6)-MID(X9,3,6)-MID(Y9,3,6)-MID(Z9,3,6)-MID(AA9,3,6)-MID(AB9,3,6)-MID(AC9,3,6)-MID(AD9,3,6)
"Aundria123" wrote:
Hello,
Thank you for your reply. When I enter this, it just puts the letter t in
front of my UNUSED UNITs #, i.e. t 41.
But I need to be able to enter either t or e throughout the whole row. And
I don't need the letter to be in the UNUSED UNITs column, only the number.
I hope this makes sense. Thanks!
"jhyatt" wrote:
="t " &text(C9-(SUM(F9:AD9))/2,"####")
"Aundria123" wrote:
Hello,
I'm a new user to excel and forumlas. I have a column that has a total
number of units in C9. In column C8 are names of people. I have to either
put next to the names T 2, T 4, E 2 or E4 (F9 to AD9). I am using the
following formula to subtract from the total number of units for each day in
the month.
Formula in Cell AE9: =(C9-(SUM(F9:AD9))/2)
This works perfectly for me when I only insert number 2 or 4. In column
AE,it gives me the number of UNUSED UNITs.
Well now my boss wants me to enter the letter T or E with the NUMBERS, and I
don't know how to adjust this forumla to IGNORE the letter so that the
formula continues to work. Right now when I add a letter to the cell, the
formula ignores the number.
I hope this makes sense as I'm desperate for a solution. I have digged
through a bunch of help sites, but I'm not technical enough to understand.
Thank you for your help!
|