calculation formula

  1. Y

    Calculating variance, sum, average for range of rows during a specific time interval???

    Hello all, I have a huge csv file with a few hundred thousand rows. I would like to perform statistical calculations on it and also obtain the first row value, for each time interval. Example for every 300seconds, I would like to calculate the variance of the total number of rows within the...
  2. J

    Is possible to sum a column and put the value below last row of the column?

    Is possible to sum column's value and put it into below last of the row? I know how to put data as last row of value, but can't figure it out how to put a value below last column. Thank you!
  3. K

    calculation based on results

    Looks like my calculations today are kinda slow since im looking into improve or get some results. i have the following: <tbody> name survey count current score failed survey good survey survey goal anderson haley 44 89.00% 4.84 ¿? 92.00% </tbody> assuming that D2 is =B2-(B2*C2)...
  4. L

    Pivot SubTotal not calculating the row but the sum instead?! PLEASE HELP ME :(

    Hi, I'm facing a real problem... and I just cannot seem to find the answer / solution for it (if there is one). I'm not quite sure how to best explain this, thus I have the below image to help. In essance, I need to buid a pivot with % (showing the leftover or usage of something). All in all...
  5. J

    Formula to choose largest number first.....

    I am a beginner in trying to write a what I think is a complicated spreadsheet but may not really be. I have looked online and cannot find a direct reference to what I am looking to do. I want to build a quoting database in either Excel or Access and am trying to determine which software would...
  6. G

    SumIf/IfStatements: Referencing more them one attribute

    Hi all, just wondering if any one can help with my If statement dilemma. I'm creating a stock tracking excel for my company and have run into a issues when writing an if statement which is reference more then on attribute on the worksheet. So far I have Created a input form in which...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top