**1**

vote

**2**answers

117 views

### How to fit mm/yyyy in SUMIF criteria

I've looked around for answers regarding this, but am still a bit confused. I have a column A in Excel with dates in the format mm-yyyy (i.e. September 1014 is Sep-14). I want to add all the values in ...

**0**

votes

**4**answers

50 views

### Excel - How to add cells that have letters and numbers

For example:
A1 - "AA123"
How do I get B1 to read "AA124" and C1 to read "AA125"?
I know that in A1 I can drag the box to the right and it will populate with this, but I need a formula for this. ...

**0**

votes

**2**answers

37 views

### Excel SUMIF Advice

I was hoping you might be able to help. I'm collected data in excel from a data source. The data source has 3 headings
Active,Occurrence,Time (seconds)
TRUE, 1, 0
TRUE, 1, 12
FALSE, 1, 12
...

**0**

votes

**0**answers

26 views

### 2 EXCEL (array?) questions

I am trying to perform some lookup calculations on a pivot table and having some abysmal luck finding the correct function/formulas to use. I've searched the Interwebs and can't find something that ...

**0**

votes

**0**answers

50 views

### Sum of Multiple VLOOKUPs

I am trying to find a formula that would help me sum the results of multiple VLOOKUPs. For example, you have two sheets that look like the following:
Sheet1
Fruit______ Orange_Apple_Banana
...

**1**

vote

**2**answers

66 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

38 views

### How to sum every second column depending on the first column value

Team,
This is driving me mad.
I know how to sum every second column in a row: ie {=SUM(A1:G1*(MOD(COLUMN(A1:G1),2)=0))}
What I need to know is how to sum all of the first columns unless there is a ...

**0**

votes

**1**answer

27 views

### In excel, add up a column so that each row in a new column shows the sum of the other column for all previous values

I want to add Column A so that it results in Column B, I've tried the Sum and SumIf function in Excel.
Column A : Column B
0 0
0 0
0 0
4 4
8 12
...

**0**

votes

**1**answer

48 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

**1**answer

37 views

### Trying to get an alert if three seperate cells do not match

Hi I am trying to put 2 formulas together in one cell
The first is to give a sum, i.e. : =(D3+F3+H3+J3)-(C3+E3+G3+I3)
The second is to check the resulting number above against a number total in 2 ...

**0**

votes

**3**answers

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

**2**

votes

**3**answers

68 views

### How to sum varying groups of numbers in excel?

I have a group of numbers:
A1 12
A2 13
A3 3
A4 5
A5
A6 1
A7 8
A8 9
A9
A10 2
A11 19
A12
and so on...
I would like cell B5 to show 33 (sum of A1 to A4), B9 to show 18 (sum of A6 to ...

**0**

votes

**1**answer

16 views

### highlighting cells and getting a sum

If you highlight two cells, at the bottom of the screen it will tell you the number of cells you highlighted as well as it will add the cells together and give you a sum. This is working for me but ...

**3**

votes

**2**answers

124 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

184 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

90 views

### sum values based in agent ID

I have a sheet with agent id's in column a and under each ID is a sub identifier with a value in column b of 1 - 7
sub identifiers are
Break_1000
Meeting_2000
Training_3000
Personal_4000
...

**-2**

votes

**2**answers

50 views

### Excel - make a sum with some criterias [duplicate]

-----A ------B------------C
1||Name ||31-03-13 ||1-04-13
2||test1 ||>>>> 150 ||>>>> 10
3||test2 ||>>>> 750 ||>>>> 11
4||test3 ||>>>> 800 ||>>>> 12
5||test3 ||>>>> 900 ...

**1**

vote

**2**answers

59 views

### sum sign in number cells

In 2 cells, I exactly have these values:
A1: 1+2+3
A2: 2+0.5+10
Is it possible to have sum of these cells (=18.5) in another cell?
I tried =SUM(A1:A2), but it returns 0

**0**

votes

**1**answer

145 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

3k 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

1k views

### Combine duplicates in Excel, sum some columns and weighted average the others

This question refers to an existing subjexct on our site. I need a variation on this solution. I have a spreadsheet with 8 data columns. The number of records can vary from a few hundred to about ...

**0**

votes

**1**answer

28 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

**1**answer

632 views

### Libreoffice Calc - Fill with Sum is not working

I want to add 2 columns of data and output the sum into a third column, with a =sum(a1+b1). With many rows of data, I try dragging down the highlighted cell to Fill the rest of the output column with ...

**0**

votes

**1**answer

149 views

### Wildcards in logical statement in excel?

I have the following formula:
{=SUM(('Data 2'!D:D>=VALUE("17-September-2012"))('Data 2'!K:K="0 out of 1"))-SUM(('Data 2'!D:D>="None Specified")('Data 2'!K:K="0 out of 1"))}
This works fine to count ...

**0**

votes

**1**answer

98 views

### How to Add one column based on the values of another column AND display into another sheet

I need to add all column G values together for each Value in column C (ndc) and display them into another sheet listing just NDC and then Total next to it. How would I go about doing that? Thanks

**0**

votes

**2**answers

974 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

256 views

### Adding value of one cell with previous value of same cell if value of another cell matches in Excel

Here is my data in sheet1 of excel:
A B
A1 20
A2 2
A1 2
A3 3
Consider the above in an excel sheet. Column A contains duplicate keys and ...

**0**

votes

**1**answer

877 views

### How can I run SUMIF or COUNTIF with two Conditions?

I recently got some great help with SUMIF and COUNTIF and ended up with the following, working formulas;
=SUMIF(REC!$F:$F,$C2,REC!$G:$G)
=COUNTIF(REC!$F:$F,$C2)
I had been mixing up the syntax and ...

**1**

vote

**1**answer

921 views

### How to use countif, sumif across two sheets where the logical test is an equivalency?

I am building a simple sum sheet that relies on a conditional but I can't seem to get COUNTIF/SUMIF to work for me.
To sum, I have two sheets, one with a few hundred lines of records including an ...

**0**

votes

**1**answer

40 views

### calculate text data

Access 2007: We have a query that performs a simple sum of two fields from two tables. But some of these fields are text and only a "X" can be entered. So, if the user enteres a negitive x (-x) we ...

**-1**

votes

**2**answers

433 views

### How to calculate running totals of subsets of data in a table

I have 4 columns: Name, Week, Batch and Units Produced (Cols, A,B,C,D). In column E, I need to keep running totals based on name and week. When the week changes for the same person, restart the ...

**0**

votes

**1**answer

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

**0**

votes

**3**answers

5k views

### Sum only if any one of six cells have a value

I would like a cell (total) to sum 6 other cells only if one of those 6 cells have a value. If none of the six have a value i do not want anything to appear.

**0**

votes

**1**answer

119 views

### How can I sum a series of tabs across tabs?

I have an excel 2007 file with 13 tabs (a summary and one for each month), and want to produce a sum up across the same cell for each month in the summary sheet.
I have tried ...

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