All Questions
172
questions
1
vote
1
answer
25k
views
How to sum a column based on existance of value in another column
I have the following sheet:
I want a sum of individual spending by Frank, John and Nancy in the yellow cells. Each person's spending is denoted by an x. I tried the SUMIF formula, but I don't know ...
0
votes
1
answer
213
views
In Excel I am wondering how if a value is met in a column then to sum up the cell to the left of that value across multiple rows if that makes sense
For example where the cell says David I want to sum all the cells on the left of David in £ up to a total like at the bottom not sure how I'd go about this.
£4500 IWI 14/12 DAVID
...
0
votes
1
answer
57
views
If Statement Gives Blank Results
I can't get the following IF statement to produce the desires results. Result comes up blank.
=IF(B3="168375","500","")
Cell A3 = 168375 so am i missing something that is ...
0
votes
1
answer
46
views
Excel - I want to get all the cells adjacent to a keyword on a page onto another sheet
I'm using Excel to track what I do every day, which includes a lot of qualitative data, and at the end of every day I write down how many hours are spent in each of several categories. I definitely ...
0
votes
1
answer
24
views
Need help in Excel Adding 2 columns
i just want to add column 2 to column 1 if and only if column 2 has just 1 text character in its cell .enter image description here
0
votes
1
answer
511
views
How to automatically sum columns datas of a grouped row subset with common attributes (excel csv spreadsheet)
I have a big csv file (one million rows) I imported in excel.
I have to do a simple operation, easy to be done manually, but I should do it for thousands groupings so I am looking for an automated ...
0
votes
1
answer
59
views
How to FIlter/Match spreadsheet data based on two row headers?
I need to find a value based on a specific column and header, that also fall within another merged header (spans 3 cells) like the example below:
|January 2020 |February 2020 |...
0
votes
1
answer
154
views
How can you format each row from a pivot table to display transposed with the headers repeating themselves?
From a pivot table, I am attempting to take each row of data and format it transposed with the headers from the pivot table present in each instance. Here is a link to a Google Sheet that has a sample ...
0
votes
0
answers
250
views
How to bring sum of previous column in to next column automatically, in Excel or Google Sheets?
I'm new to this. I'm trying to make a personal budget sheet, where I can bring the previous months' sum into the next month's column as "savings from last month". Basically I want to show ...
0
votes
2
answers
1k
views
Excel SUMIF/SUMPRODUCT with Dates Identifier?
So I am currently working with a spreadsheet of data that has info on a set of loans and how they payback over time. I'm trying to create a table that sums their payback based on what month they were ...
0
votes
3
answers
52
views
Microsoft Excel - Rolling Average with Skips
I have a table of costs among several different locations for the past x years. For each location (A, B, C), I would like to find the average cost of the past three visits. Unfortunately, locations ...
0
votes
1
answer
166
views
How to Calculate the Average after a certain date
Im trying to get the average of days taken to send to college but i only want it to take in to consideration dates received after 17/05/2021.
can anyone help
0
votes
2
answers
1k
views
Excel Formula to increment day by one except if it's a weekend
Basically what i want is for weekdays to increment by one every day but for weekends i want each day to display twice, so each weekday will have one row and each weekend will have two the current ...
2
votes
1
answer
1k
views
CONCATENATE cells in a column IF condition in other colum is met
Using Google sheets (or Excel if Google sheets can't do it). I'm trying to concatenate any cell in B column, if its corresponding A cell is "include". The columns are very long and therefore ...
0
votes
1
answer
236
views
Excel - sort one spreadsheet by exact order of second spreadsheet based on one column with same data
I trying to find a way how to sort one spreadsheet into the same order like second spreadsheet - based on their one same column for example.
Here's an example what i need, i will make more sense like ...