-2
votes
1answer
36 views

How to calculate monthly sum from the entries for each date in Excel?

I have colums for my workout logging: Date Running (minutes) Pushups Pullups Crunches and the rest of my workout entries. I insert my achievements each day. How can I script Excel to ...
0
votes
1answer
113 views

Numbers/Excel Hour Counter within Specified Date Range

The data shown in the image is just sample information but... I would like to use the "Period Beginning" and "Period End" to create a range to determine the total number of hours and earnings. I ...
0
votes
1answer
2k views

How do I add values in column B if column A contains the same employee surname more than once?

State of Data: I have column A which has names of employes and column B has number of hours. How do I add the hours if column A contains same employee surname more than once? I have been using what I ...
0
votes
1answer
24 views

How does one add all values that occur before a specific date?

I know I need the SUMIF function, but I can't figure out the condition for the life of me. Given the following table, how would I get $150? Value | Date ------+--------- $100 | 1/1/2013 $50 | ...
0
votes
2answers
567 views

Positive result, negative result and current balance. How do you make starting balance show current result?

I have 3 columns: Column A shows positive result and if the result is negative then it is in a column B. Column B shows negative result and if the result is positive then it is in a column A. ...
0
votes
1answer
236 views

How to omit header values in Word formula?

I am new to superuser. Kindly pardon if I make some mistakes. I am working with tables having numerical data in Word (no not even embedded Excel tables - don't ask why). It so happens that many ...
5
votes
2answers
1k views

Excel: Counting number of MAX values in a range

I am using Excel 2003 (version limited due to corporate policy) to keep a score sheet: A B C D 1 Round | Rita | Sue | Bob ------+------+-----+----- 2 1 | 5 | 3 | 4 3 ...