Excel Formula

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have a spreadsheet to log a persons manhours performed
for the month. 31 columns with a totals column to follow
the last day of the month.
We are a military organization and there are a number of
different statuses that a guy could be in on a given day.
If, on the 5th, the guy works a drill I want to record it
as a "U" so I know his status for the day. I want the
totals column to read that as 8 hrs worked. How can I get
my totals column to recognize an alpha character as a
number?
Mark
 
Assuming alpha characters are recorded in row 1, try:

=SUMPRODUCT((A1:AE1="U")*8)

HTH
Jason
Atlanta, GA
 
Hi Mark,
Good for upper or lowercase, each "U" counts as 8 units.
=SUM(A:A)+COUNTIF(A:A,"U")*8
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula help 3
Sumproduct formula help needed 6
Excel 2003 running on XP 2
Formula Question 2
Macro to add numbers in a text string 5
how do I get a cummulative total in excel 1
Excel Excel VBA Script help 0
Convert Text in cell to hh:mm:ss 12

Back
Top