# Tagged Questions

**1**

vote

**2**answers

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

**1**answer

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

**3**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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 ...