0
votes
1answer
34 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
3answers
21 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
3answers
28 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 ...
3
votes
2answers
95 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 ...
-2
votes
1answer
75 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
58 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
2answers
47 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
2answers
58 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
1answer
127 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
767 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
1answer
125 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
1answer
92 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
2answers
728 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
209 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 ...
-1
votes
2answers
356 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
3answers
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.
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 ...