Addition In Base 6

Jun 14, 2009

I've got a column of numbers that represent the number of overs bowled in games of cricket. Whilst these are whole numbers (eg. 34 overs + 34 overs) the addition isn't a problem, but when they are incomplete overs (eg. 34.4 overs + 34.5 overs) then the addition if out of kilter as it sums them in base 10, and not in base 6. (As there are six balls in an over, not ten for anyone who doesn't know!)

ADVERTISEMENT

Make A Calculation(addition) And Use The Answer To Multiply Against Another Addition Calculation

Nov 19, 2008

make a calculation(addition) and use the answer to multiply against another addition calculation....

The sum of (Monday!A1:A4) multiplied by the sum of (Monday!B1:B4) plus (Tuesday!A1:A4) multiplied by the sum of (Tuesday!B1:B4) and so on.

View 2 Replies View Related

Addition Of Cells

Feb 8, 2007

I wanted to have the weeks of the month down one column = 52 week.

down the next column I have different amounts of money in that week.

some months have 4 weeks and other have 5. I wanted a program to say:

If you see a month "x" look at the next column and take that amount. Then on the next row you have month "x" again (week 2) go to the next column and take that amount and add it to week one. And so on until all 4/5 week are added to give on result.

Then the same for the next month...
month amount/week amount/month
05-Mar 0
12-Mar 70
19-Mar 210
26-Mar 350 1050
02-Apr 420
09-Apr 455......

View 9 Replies View Related

'Remote' Addition

Mar 16, 2009

I am hoping someone with excel experience can be of help to me with an unusual request for excel.

Assume cell A1 = 2, B1 = 3 and i wish the sum of this (5) to appear in cell C1. Very straight forward so far, however i wish the result to appear in C1 when i left click on a cell other than C1, say for example D7.

I can't use any macros for this.

View 11 Replies View Related

Sumproduct - Addition By Name

Jun 11, 2009

I need to C8 - C19 only to add up jobs won by andrew (in current orders). It needs to be month specific. what i mean by that is I need the formula to do what its doing now (adding up the jobs by and putting the totals into the according cell depending on what month they were won.

View 2 Replies View Related

Vlookup & Addition

Dec 28, 2009

I have multiple ranges in a spread sheet. I am trying to write a formula that will go out to each range in succession and look for a part number, upon finding return a quantity and them move on to the next range duplicating the above process. The formula should tally the grand total of all numbers found. I have it working except that not all of my items are in all ranges. If the item that I am searching for is in all ranges my formula works but if there is one or more of the ranges that doesn't have that particular value it returns an #n/a instead of totalling those that do have it. If I use a true instead of false in my [range_lookup] I get an incorrect answer. My formula for a given cell is listed below. This is with the true argument which does not work....

View 9 Replies View Related

Addition Formula

Aug 13, 2008

I am a new excel user. I a trying to write a certain formula but am having trouble. I want to write the formula to add a column of numbers, say H-10 through H-15. Each cell will have a number in it, but I want only to add the cells if the cell precedding it in the G-10 through G-15 Collumn is blank. For example if cells G-12 and G-14 have an "X" in them, then I do not want Cells H-12 and H-14 to be added. I only want the formula to add cells H-10,H-11,H-13, and H-15. I used just 6 cells for example, the column of cells to be added will be a lot longer.

View 3 Replies View Related

Multiplication/addition Function

Jan 27, 2009

I obviously know less about functions than I thought I did. I've got the attached spreadsheet set up except getting totals at the bottom. The production total L44, would be column A multiplied by the quantity entered in columns L and summed. Same for Total SF, square footage in column B times quantity in L and summed at the bottom. This would continue daily, needing sums under each column.

View 4 Replies View Related

Algorithm For Addition (operation For Each ID)

Sep 25, 2009

Have an excel table with following data:
- ID
- number of bottles
- number of bottle crates (there are 20 bottles in one one bottle crate)

201688194000bottles
20168819200crates
2016883812000bottles
20168838600crates
201688396400bottles
20168839320crates
201688809000bottles
20168880600bottles
20168880480crates...................

I need to write a macro which will do this operation for each ID:

(bottles/20)-crates = x

and if "x" is not 0 then write down the value of "x".

There are two points I would like to point out:
- One ID may contain 3 or more rows (see 20168880)
- The macro will work with hundreds IDs so the algorithm should be fast (but it is not necessary)

View 3 Replies View Related

Insert Addition Formula With VBA

Jan 11, 2013

I wish to sum specific rows in a spreadsheet as a Grand Total. I eventually end up with a string variable called "GrandTot" that holds "=C3+C13+C25+C31+C39+C50+C53"

This formula is correct, but when I insert it into the spreadsheet it totals zero. Only when I manually write the formula does it recognize the cells it supposed to add. I am very confused as to why this is happening.

On a possibly related note, when I highlight a column in the spreadsheet, the count is including blank cells.

View 3 Replies View Related

Addition Of Hyperlink To Macro

Jan 16, 2013

I have a macro that basically captures all of the errors in my spreadsheet and summarizes them under 3 columns (Value in Cell, Sheet, Cell) so that I can quickly identify the error message as well as it's location. I wanted to take it a set further and add a hyperlink for each error so that the user can quickly go to the error location to investigate. I really don't care where the hyperlink is located as far as which 3 columns.

Range("G2").Select
Selection.End(xlToRight).Select
Selection.End(xlDown).Select
Selection.End(xlToLeft).Select
Selection.End(xlUp).Select

curRow = ActiveCell.Row + 3

[Code] ........

View 6 Replies View Related

Addition And Subtraction Using IF Formula

May 1, 2013

Lets say I have a #2 in cell A1 and #4 in cell B1 and would like an output in C1 as "plus 2".

Right now I have =if(a1>b1,b1-a1,???) what can I put in the [value_if_false] to return "plus 2" or do I have to use another formula?

View 1 Replies View Related

Addition Of Brackets Within Cells?

Jun 30, 2014

I have this in cell F5

CM26 (85) CM16 (39) CM25 (12)

I need to add the numbers in brackets up and put the total in G5.

View 3 Replies View Related

Addition Of The Values In The Cells

Mar 27, 2009

I AM HAVING DATA OF 210 BRANCHES OF DIFFERENT ITEMS. EACH BRANCH HAS AROUND 100 TO 150 ITEMS. I WANT TO ADD THE VALUES OF EACH BRANCH AND I HAVE TO GET THE GRAND TOTAL VALUE IN A SINGLE SHEET. SUPPOSE IF ADD E10+E210+E350+E470 LIKE THIS AFTER SOME pLUSES I WILL GET THE FORMULA RANGE IS OVER. IS THERE ANY METHOD OF ADDING 210 BRANCHES ITEMS

View 9 Replies View Related

Counting Number Of Amounts In Addition?

Jun 16, 2014

I am looking for a method to count the number of amounts in an addition.

For example, let's assume that A1 contains 354.92+29+84.7+45 That addition contains a total of four different amounts that have been added So, I am looking for a formula that will display the total number of amounts (4) in a different cell.

Another example:
A1 -> 75+9+237
A2 should show -> 3

View 7 Replies View Related

Sumproduct, Skipping Columns, Addition

Dec 29, 2008

I have Names in column A, Data in Column B. Example

A1 John B1 1000 C1 5:32:05
A2 Jim B2 500 C2 5:56:55
A3 John B3 600 C3 6:45:65
A4 Bill B4 300 C3 7:21:05

In another column I have the names of all the possible people that I will need data from and next to them I will need a formula to tabulate all their totals from column B and then another formula that will skip B and total column C's total.. I have a formula that I used from awhile ago when I needed to offset the data but I can't figure out how to just take the data to the right of it and then another formula to skip column B. Here is my old formula =SUMPRODUCT(($A$1:$A$291=G14)+0,OFFSET($B$1:$B$291,1,0)+0)

View 2 Replies View Related

Simple Conditional Addition Function

Mar 27, 2009

I imagine this is a simple conditional SUMIF function. I'd like a cell to add values in e.g. column "d" when that row meets certain criterion in column "a".

In other words, I have a column that has times recorded in minutes, and another that says a person's name which correlates with the times. I'd like a cell on another sheet to give a total sum of minutes for each person.

Ideally, part of the function would translate the minute count into hours/minutes, but I think I can figure out how to do that by changing the format in the cell...

View 6 Replies View Related

Calculator Formula For Addition Via Columns

Oct 20, 2009

I would like to know the calculator formula for addition via columns.

Eg 1. If i were to place 135 into Column A ;
12.95 into Column C ;
i would need to yield a result of 147.95

Eg 2. Place 189 into Column A ;
12.95 into Column C

i would need to yield result of 201.95 and so on. in the attachment is the sample file.

View 2 Replies View Related

Addition/Subtraction With Menu Selection

Jan 8, 2009

Included is an example of a spreadsheet I am working on. There are multiple choices within several different drop-down menu's. As of right now I have the 1st menu as the stage of completion of a car. Within the next few menu's are options.

If welded chassis is chosen, none of these options are included. However if roller or turn-key are chosen then some of these options are included. But then there are also upgrades to these parts that are included as well. Is there a way to make 1 option included when a roller is chosen, but then if you want the 2nd option in the menu, you click on it and it automatically updates the price next to it, therefore subtracting the cost of option 1 from the cost of option 2?

View 2 Replies View Related

Date Not Cycling With Addition Of Time

Oct 26, 2011

Adding date and time. The code is listed below.

I have watched the code while running. The initial date FDateS and FDate(t) value is m/dd/yyyy (9/16/2010) and no time. FDateS has different amounts of time added to it. The issue I have encountered is that once it passes midnight, the date does not change but the time reflects the change to 00:00:00.

Public FDate(1000) As Date
Public FTime(1000) As Date
FDate(t) = CDate(Mid(FindData("sm_Sys_BatchOpenTime"), 1, 10))

For H1 = 1 To n
FDateS = FDate(H1)
For r =1 to 50
FDateS = CDate(FDateS) + CDate(FTime(r)-Ftime(r-1))
Next
Next

View 1 Replies View Related

Addition With Specific Criteria Over Two Columns

Nov 26, 2012

I have two columns with numbers in ranging as follows:

2
2.5
3
3.5
4
4.5
5

On the spreadsheet it looks like this:

4.5
5

4
4.5

3.5
3.5

3.5
4

3.5
3.5

3
3

3.5
3.5

What I need to show in the next column is a True where these two figures add up to 8 or more. However, the minimum in each column needs to be 4 and 4 i.e. if one column has 3.5 and the next 5 then return a value of False.

View 7 Replies View Related

Fill InThe Blanks Addition

May 22, 2007

I have some great code that HalfAce provided a while back that I think will fit a project I am working on, but I can't see how to modify it to fit this one. I need to have it look at a location and provider and find the most "common" date. Then for that criteria fill in the lines with no dates with that "common" date. Here is the code that I need to modify for this

Sub FillInTheBlanks()
Dim LstRw As Long, _
DescRng As Range, _
AccntRng As Range, _
Desc As Range, _
Accnt As Range

LstRw = Cells(Rows.Count, "B").End(xlUp).Row
Set AccntRng = Range(Cells(2, "B"), Cells(LstRw, "B"))
Set DescRng = Range(Cells(2, "I"), Cells(LstRw, "I"))

View 9 Replies View Related

Function Of Addition With An Only Conditional Criterion

Mar 23, 2009

I behind developed to a time a function of Addition with an only conditional criterion.
I would like to extend at least for three criteria, this function I function accurately as the function SUMPRODUCT alone that done in VBA.

Function VlookupAllSum(name As String, IntervalSearches As Range, IntervalReturn As Range) As Variant ' as integer para valores até 32.767
Dim Valor, Nome
Dim lin, col As Integer
Dim Total
Application.Volatile
lin = 1
col = lin
For Each Nome In IntervalSearches
If Nome = name Then
Valor = IntervalReturn(lin, col)................

View 9 Replies View Related

Addition Of Values In A Single Cell

Apr 14, 2006

see the attached sheet. It already has some example....I need the result of the addition in the cells of column F, at the side Say column G, in the coressponding row. e.g for cell F9, I need the result in G9, and so on. For testing, step 1. Select M+R in Col "TOI", enter some value in the pop up. step 2. Again select M+R in "TOI", enter some value in the pop up. the Col F will have some additions (e.g 1+2), for which I need the result in the corresponding next column. i.e col G.

View 4 Replies View Related

Update Csa Formula With The Addition Of New Rows

Jun 20, 2007

I am working on a spreadsheet that matches each cell in Column B (text) with the data (text) in a constant cell; if there is a match, the data that corresponds to the data in Column B (text) will average (Column G, number) using a CSA formula, for example: =AVERAGE(IF($B$3:$B$106=A$110,$G$3:$G$106))

Now the formula above works well, only I have to update the spreadsheet, so when I add new rows the $B$3:$B$106 and $G$3:$G$106 portions are useless.

Trying to use the INDIRECT function that many people successfully use in this forum, produces a #VALUE error,

=AVERAGE(IF(INDIRECT("$B$3:B"&ROW()-4)=A$111,(INDIRECT("$G$3:G"&ROW()-4))))

View 9 Replies View Related

Basic Addition, Subtraction & Multiplication

Apr 12, 2008

Take a single cell in column D, and multiply it by a single cell in column E, which will equal F. Take column F, and multiply it by .02 (2%), which will equal G. Take a cell in column G, and subtract it from F, which will equal I. And this all takes place in the same row. Then have it move down to the next row, and do the same thing..... so it would basically look like this.....

A B C D E F G H I
1 D1 E1 (D1*E1) (F1*.02) (G1-F1)

2 D2 E2 (D2*E2) (F2*.02) (G2-F2)

3 D3 E3 (D3*E3) (F3*.02) (G3-F3)

For easier reading.... in each row I want it to do the following math
D*E=F
F*.02=G
G-F=I

And then do it for every row that I have data in (excluding the VERY first row). I am -COMPLETELY- sorry if I broke any rules, and am also sorry for the poor representation

View 5 Replies View Related

How To Sum Column Base On Few Criteria

Feb 17, 2014

I would like to sum the amount column of unique date that is in active status of each account.

Account Date Status Amount
11 jan 1 A 200
12 jan 1 A 5
13 jan 1 A 1000
11 jan 1 A 200
11 jan 3 A 100
12 jan 3 A 8
13 jan 4 A 1
13 jan 4 A 1
11 jan 6 I 50
12 jan 6 A 10

Below is the expected result
Account Amount
11 300 (200+100) [200 is only add once since jan 1 of 11 has appeared more than one time]
12 23 (5+8+10)
13 1001(1000+1)

View 5 Replies View Related

Hyperlink Base Does Not Work

Mar 7, 2012

I have entered this value into a cell on my worksheet. It is referencing a cell in another worksheet on a shared drive on my network.

='\servershare$[doc1.xls]Sheet1'!$A$1

All is fine until I re-open the document, whereby it has changed to:

='\serverusers$share$[doc1.xls]Sheet1'!$A$1

I have been advised to set the hyperlink base as \servershare$

...but this clearly does not work.

View 4 Replies View Related

Array In Data Base

Apr 21, 2006

i have used the database from j & r solutions. i have altered it slightly to suit me. the database works fine apart from when using the find all button it will only return 4 entries. if there are more than 4 entries it returns runtime error 9.i have zipped up the code and marked where the error is shown when i debug

View 2 Replies View Related

Excel VBA Array Scalar Multiplication And Addition

Oct 20, 2012

I have two columns of data in an excel sheet that are equal in size and both only contain numbers.

I'm trying to write a macros which will put both of these sets into arrays, then perform a calculation on them.

Specifically ArrayA + 3*ArrayB then put the result back into the worksheet in a new column. Below is the code I have so far.

Dim ArrayA As Variant
Dim ArrayB As Variant
Dim ArrayC As Variant

ArrayA = Worksheets("Sheet1").Range("A1:A5")
ArrayB = Worksheets("Sheet1").Range("B1:B5")

This is where things go bad
ArrayC = ArrayA + 3 * ArrayB

View 4 Replies View Related

Addition Of Alpha Numeric Using Function COUNTIF

Mar 18, 2014

I am trying to create a shift roster for my team. My team work in general shift (GS), second shift (SS), third shift (TS). There are situations where some team members come in any of these shift but had to leave midway due to feeling well, so that should be counted as half day. This half day scenario may be in any case GS/SS/TS. I am using COUNTIF to get the sum of GS/SS/TS for each employee which is giving a whole number. I also want to incorporate 3 different variations of half day as Half Day GS (HG), Half Day SS (HS), Half Day TS (HT). My expectation is that for each Half Day only 0.5 should be added in a appropriate shift, but COUNTIF is always counting this as 1. How I can achieve this using countif or any other Excel function? Sample sheet is attached.

View 3 Replies View Related

Addition Calculation Not Giving Correct Answer

Feb 20, 2009

I have a workbook with calculations for a sale less the assorted fees and at the end giving the final amount from a sale.

I have noticed that some of the rows are not giving the correct amount in them.
In other words the addition of some columns in that row are not adding up correctly. It is only off by 1 cent (either over or under), but I can't figure out why.

I have the feeling that I am going to want to kick myself when someone explains this to me (I just know that I know the answer but for the life of me I can't right now).

View 2 Replies View Related

Sumif Formula Needs To Split 2 Criterias Of Addition

Aug 6, 2009

you guys very kindly helped me with a spreadsheet a couple of months ago, but i now need to adapt it for another dept. I have completed as much as I can.

I need column C and E in the 'totals tab' to only calculate contract and upgrade sales respectively (found in 'service orders' tab). I also need Scott's and ash's individual sales to be calculated in corrisponding tabs. Most of the formulas are in place so just need them tweaked slightley.

View 4 Replies View Related

Subtotal Formula - Function 109 Does Subtraction (not Addition)

May 28, 2013

I'm looking for a formula that acts the same way as the subtotal formula (revises if rows are hidden and only adds visible rows). Is there anyway to get this removal of hidden rows but for subtraction?

View 3 Replies View Related

Update Function In Cells Following Addition Row Insertion

Jan 14, 2014

I have a command button that runs a macro to insert two new rows between row 15 and 16 no real problem (see code & sheet below), but I would like the Total Hours and Total Cost rows to include the newly added rows i.e.

Rows 16 & 17

Cell B18 now contains =B2+B4+B6+B8+B10+B12+B14+B16
and
Cell B19 now contains =B3+B5+B7+B9+B11+B13+B15+B17

If another two rows are added then Total Hours and Total Cost Cells 20 & 21 will now be

Cell B20 now contains =B2+B4+B6+B8+B10+B12+B14+B16+B18
and
Cell B21 now contains =B3+B5+B7+B9+B11+B13+B15+B17+B19

Command button Code to insert row

Code:
Private Sub CommandButton1_Click()
Const fWhat As String = "EXTERNAL"
Dim sR As Range, fR As Range, fAdr As String, nRw As Long
Set sR = Range("A1:C187")

[Code] ..........

Worksheet Below
1
Hours
170

Cost
387.99

[Code] ...........

View 1 Replies View Related

How To Change Base Unit Of Charts

Dec 11, 2013

I'm working on a charting application that uses Office charts. I'm wondering what are some of the main reasons people change the base unit from the default, and how common that is.

Some reasons I've identified on my own:You're comparing different monthly metrics, but they could be recorded on different days of the month.Get a zoomed-out view.Compare the max value of each month.

View 3 Replies View Related

Return Value Base On Top X Highest Rank

Dec 18, 2013

I have done many research online to cater to my require but fail to accomplish it. I need to determine the decision base on ranking of the number in the Rank column. which is than reflected in the calender. But per day basis, it needs to only be green for the top "number of quota set per day" highest ranking. I have also attached the sample for a clearer understanding

Sample.xlsx

View 4 Replies View Related

Transferring Data From A Row Base On Value Given From One Sheet To Another?

Jul 17, 2013

We have database (attached here). I want to copy the name of candidates base on their Status to their designated tab. example Diana Longoria name will be copy to "Waiting" Tab and if I change the status to "Rejected" it will be copied to "Rejected" tab and remove name from "Waiting" tab.

View 12 Replies View Related

Use Access Data Base For Project?

Jan 12, 2009

I am working on a spreasheet that will automatically calculate the interest rate, loan to value advance, and other parameters from user inputs.

I have found a way to get the calculations to work correctly, but I have about 50 lenders to input - all with different rates and lending guidlines with respect to loan to value advances.

I am sure that I am going about it the hard way and I have no problem going at this to get it right.

I have attached the spreasheet I've started. I've only got one lender completed thus far. So if you need help sleeping at night, go ahead and see what I've done (yes it's boring).

Edit note: I don't know if using Access would make this an easier project to tackle but it is an option (I'll just have to learn
Access if that's the case - I've never used it).

View 3 Replies View Related

Time / Frame Fps Formula (base 75)

Jan 18, 2010

I have a formula that calculates only seconds and frames. The frame rate is 75 fps (0-74).

e.g., 49.50 is 49 seconds 50 frames. It will not parse Minutes.Seconds.Frames, e.g., 1.49.50 is 1 minute 49 seconds 50 frames.

What my existing formula does is converts the number to all frames then converts the answer back to seconds and frames.

I need this formula to include minutes in its calculation.

A copy of the spreadsheet is here: ...

View 14 Replies View Related

Formula - Calculate New Base Pay Rate?

Dec 27, 2012

I am trying to calculate a new base pay rate, but I need it make sure it is at least brought up the new minimum and capped at the new max of the range where applicable. The increase is based on 10%

So here are the columns used:

L = Current Base Pay
Q = New Min of the range
S = New Max of the range
U = where I want to calculate a 10% increase of L, but ensuring it is brought up to at least the min (Q) or not over Max (S). In other words if my min is $12 and Max $18 and my new base pay is $16 -- then I am good. However it if is $11.50 I need the formula to return at least $12. And visa versa -- if the new rate would be $18.50, I need it to return no more than $18.

View 3 Replies View Related

ADVERTISEMENT