1
vote
2answers
36 views

Excel to calculate summation with exclusion list

Say I have a table like below: Task Time a 1 b 2 c 4 d 8 -------- sum 15 When a task is finished, I would like to add strike line to the row and exclude it from summation. Adding ...
0
votes
1answer
36 views

sumif(s), sumproduct for many to many relationship

I am looking for a formula/function that will allow me to essentially SUMIF(s) across a BOM. I know my part to FG relationship (Part, FG) and I know how many FG's I need(FG, Qty). How can I ...
0
votes
3answers
25 views

Is there a way to combine duplicates within a large range in Excel?

I have a large (1.7 million rows) table of sales data on a sheet in Excel, many entries of which are identical other than a unique ID and a timestamp. I’d like to consolidate this data by combining ...
3
votes
2answers
106 views

Sum of N-highest number in a series excluding duplicates

I had gone through the thread Sum up to N-highest value of series and it's not exactly what I need. e.g. =SUM(LARGE(Range;1); LARGE(Range;2); …; LARGE(Range;N)) The question is if the data set has ...
-3
votes
1answer
108 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
129 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 ...
1
vote
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
26 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
825 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
255 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
2k 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 ...