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

learn more…| top users | synonyms (5)

-1
votes
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
1answer
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
0answers
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
2answers
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
0answers
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
0answers
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
2answers
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
0answers
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
1answer
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
1answer
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
2answers
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
0answers
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
0answers
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
1answer
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
0answers
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 ...

153050per page