Questions about using in-cell functions/formulas in spreadsheet software.

**-1**

votes

**0**answers

28 views

### I need to calculate all the extra working hours in a month in excel

Hello I need to calculate the extra working hours of a month but there is a twist:spreadsheetIn the first row we have the dates of the month (01=01/01/2018, 02=02/01/2018) in dd/mm/yyy format. ...

**0**

votes

**1**answer

24 views

### Excel: Data across multiple columns and rows

Currently have a table like this:How can I consolidate and count the hours per person spent on each day. Need to be on seperate lines due to working on different tasks but want to bring in all ...

**-2**

votes

**0**answers

17 views

### how to Return a sum value using multiple conditions in two or more columns [on hold]

I am trying to find a formula to resolve the following:Column A has three criteria and Column B has five criteria. I would like to have the summed value in column C for each criteria in Column A ...

**0**

votes

**1**answer

17 views

### Excel - How to subtract cells and add columns

So lets say I have 2 columns, A e B, like for example:A B C -----------------------------1 | | A | B |-----------------------------2 | ...

**1**

vote

**1**answer

21 views

### Need a Formula to add the current date in a specific cell that data is added to another

I have a spreadsheet that has to have data entered into it each and every dayWhat i would like is that when Data is entered into lets say A1 that the current date is put in G1. And every day when ...

**-1**

votes

**0**answers

24 views

### SUMIFS function to reuse data from the same criteria in EXCEL

I'm trying to make a dynamic cash flow for my budget calculation.I already did my normal "IN/OUT" since they don't have any dynamic cells.However, I'm stuck in the Loan criteria because i'm using ...

**0**

votes

**0**answers

14 views

### MS Excel SUMIFS with filtering criteria

I have a table "Balance sheet" likeA B C D E F2 REVENUE | $100.94 | | Starting Date | End Date | Category3 | ...

**0**

votes

**0**answers

10 views

### How to use dynamic file names in Excel?

I have a set of workbooks set up for work where there are multiple, identical sheets reporting key metrics back to a supervisor's workbook. To improve efficiency and lessen my workload when new ...

**2**

votes

**1**answer

33 views

### Counting cells that contain=

I am trying to count cells that contain the=sign. I have done this many times before but for some reason this time it is counting the blanks and none of the=signs. The formula used is=COUNTIF($...

**0**

votes

**0**answers

10 views

### MS Excel perform Sumif and filter criteria

In cell H1 I want to sum D:D only if values are >0=SUMIF(D:D,">=0", but I also want to consider filtering which only works by using=SUBTOTAL(9,D:D), the problem is that I want both, how can I ...

**1**

vote

**2**answers

26 views

### Visual Basic - VBA code to skip or ignore rule if cell contains certain value

I have written the following VBA code to automatically populate column "P" with "pending", "Not due","-" based on the value of column "O".The user will manually have to enter "complete" into column "...

**1**

vote

**0**answers

34 views

### Is there a way to apply conditional Formula in Excel?

My basic issue is, can I apply a Formula which use the Cell value as condition?Now let me explain what I need.I have a Spreadsheet having list of inventoried Aluminium extrusions. I want Counts to ...

**0**

votes

**0**answers

14 views

### Converting a mathematical formula into spreadsheet formula in LibreOffice

I got a great answer to a maths question on the maths SO. However, for the life of me, I cannot think how to make use of it in any practical way.I have a spreadsheet with the values of k and n in ...

**1**

vote

**1**answer

14 views

### LibreOffice Calc | How to reference a column (to iterate all rows) using a formula in “Find & Replace”?

i have two columns: A and B. In column A, there is some currency values (all positives). In column B, there is a value that indicates if column A value is positive or negative.i was reading the help ...

**1**

vote

**2**answers

57 views

### Copy Excel formula itself to clipboard

There are many questions about copying values instead of formulas, but what I am seeking is exactly the opposite. I want copy the formula itself, not the result of its calculation from some cell, and ...

**-1**

votes

**0**answers

17 views

### Excel Sort Intra-cell contents [on hold]

Hi, Looking for a user defined Excel function to sort intra-cell, with flexibility like this:=MyIntracellSortFunction ( vRangeToSort, vIntraCellDelimiter, vAscendingDescending, vRemoveSourceDupes, ...

**0**

votes

**1**answer

59 views

### Rearrange Lists of Rows in One Spot Based on Chronological Order of Dates in Those Rows

I have four courses that I want to plan this term. I listed each course's data of tests and assignments in separate tables in excel as following:I want to solve the problem of compiling and ...

**1**

vote

**1**answer

47 views

### MS Excel vlookup return only single instance

I have A sheet likeA | B | C |1 Customer 1 | Product 1 | $150 |1 Customer 1 | Product 1 | ---- |2 Customer 1 | Product 2 | $50 |3 Customer 2 | ...

**1**

vote

**1**answer

39 views

### Count rows where specified values appear in specified columns

I currently have a worksheet with sample data:| A | B | C |---------------------------------------1 | SHAPE | SIDES | COLOUR |-------------------------------...

**0**

votes

**1**answer

39 views

### Excel Multi Conditional Formatting Questions

I need a formula that will look at the text in one cell and compare it to three other columns and highlight it a specified color. Here's the example:DataCell A2 contains "This is the sample text ...

**0**

votes

**2**answers

33 views

### Why is the fill behind text in filled excel cells different than the rest of the filled cells?

For some reason, this problem started in all of my spreadsheets yesterday, so I must have clicked something, but I do not know what it could be. Here is the problem: I have a filled cell. I type ...

**0**

votes

**2**answers

57 views

### What type of formula should i use

I have two basic issues. First is that, I'm trying to Count Yes & No entries in the Row. Other one is, if NOs are either 3 or 4 Formula should return 1 and if NOs are 6 or higher it should ...

**-1**

votes

**0**answers

6 views

### Concatenate in side an arrayformula with google sheets [migrated]

I want to concatenate column A to the end of a url for every row A isn't null. This is just adding A:2 to the end over and over any ideas?=ARRAYFORMULA(IF(ISBLANK(A2:A),"",CONCATENATE("http://www....

**0**

votes

**1**answer

41 views

### Index Match and SUM with multiple criteria

I am trying to get the sum of rows based on a index match lookup from the below tableMonthly tableI am looking at changing the the sum range in the row based on the date I select. for example If I ...

**0**

votes

**1**answer

28 views

### Creating totals if values exist in nearby column in Excel

I have an Excel spreadsheet like below. Colors are selected from a set list in column A and have a measurement (>0) in column B. I would like to create formulas in the cells under "totals" that ...

**1**

vote

**2**answers

44 views

### Excel: using a formula to only sum from above row until next blank cell?

I'm a bit of a noob so bear with me. I'm making a spreadsheet of various products bought and sold at various prices. The table is sorted by product, with a blank row separating each complete buy-sell ...

**0**

votes

**0**answers

10 views

### Pre-populating a result based on two different drop down menus

I'm creating a form that includes two drop-down menus. Each menu is independent of the other. What I need to do is create a formula that will populate information in another cell based on what's ...

**-1**

votes

**0**answers

16 views

### Excel/Google Docs - subtract one value from another if #1 cell value=WEEKNUM(TODAY() and #2 is not 0

I'm going a bit spare trying to work this out.I have a table as follows, detailing the week number and store name.The values in the table are the number of visits by area managers:Store / Week | ...

**0**

votes

**1**answer

16 views

### Duplicate values of a series of cells

I have an Excel file that contains 3 columns. The first column contains the country/region codes, the second the country/region name and the third column contains the year.In total I have 354 ...

**-1**

votes

**0**answers

22 views

### Add distributed dividend cumulative total on to a column for different dates

My goal is to calculate the total end stock price (equals to the cumulative dividend till that date + stock close price)I have a table with dividend pay dates and dividend amountenter image ...