Questions tagged [worksheet-function]
Questions about using in-cell functions/formulas in spreadsheet software.
2,598
questions with no upvoted or accepted answers
-2
votes
1
answer
141
views
Count number of rows in a column with an entry if that entry is the first entry in the row
I'm looking to count the number of rows in a column that have an entry only until that same row has a second entry. In the example below, that would be a count of the cells in the columns which are ...
-2
votes
2
answers
681
views
In Excel, is it possible to get one specific cell from another workbook to show in another workbook, and automatically update?
I've got several workbooks, and I need to collate the information from these on to one master sheet - the problem is, I don't need to import all the information, just the final result (A literal Yes/...
-2
votes
2
answers
5k
views
Excel Countifs function keeps returning "0" value
output "# in Title" that returns an error of "0"
where data is coming from
I am trying to see how many departments contain a given title code (a 4 digit code assigned to each job title). There is 1 ...
-2
votes
1
answer
2k
views
On Excel 2015, want to assign a value to a word, "yes" =1,"no"=0
I made an If statement and place it into the column.
=IF (H1="yes",0,1)
This works fine for the individual cell in a column, e.g in column H, cell one.
Then I had to repeat this equation for ...
-2
votes
1
answer
92
views
Filter in Daily cash Transactions
I have a daily cash transactions sheet which looks like this.
What formula do I have to put in F column so that when I apply filter datewise, I get a result like in the second picture? I have tried ...
-2
votes
1
answer
94
views
Excel 2013 formula for Missing Data
I have a spreadsheet with over 5,000 records.
Spreadsheet contains new system users who need to be set up with two customer levels "account planning" and "financial control" for each of their ...
-2
votes
1
answer
156
views
Copy and Pasting using Macros in excel 2007
I'm trying to Copy from a row of text in the "lookup sheet" column and paste into row two starting at CCX2.
For example I need to copy 2856FRGM and paste into 12 cells (CCX2 - CDI2), then followed by ...
-2
votes
1
answer
31
views
Compare 2 Columns and count results
Struggling with what i hoped was a simple task, (it's been a long day) i have the following table where locations are in Col A, and Y/N is in ColB if they have replied to feedback.
ColA - ColB
...
-2
votes
2
answers
505
views
How to combine several array arguments - SUMIF(S)? SUMPRODUCT?
I would appreciate input on this.
Date Value
7-Feb-2016 100
20-Feb-2016 200
15-Mar-2016 300
25-Mar-2016 400
My two criteria for a summation are
Date must be <= 31 Mar ...
-2
votes
2
answers
9k
views
Excel how to sum all cells with the same name
I have a workbook with 30 or more sheets. Specifically, each sheet may be an invoice, change order, etc. such that the format of each sheet is not the same as the next one.
The named range Total on ...
-2
votes
1
answer
4k
views
# of days in a month based and start and end dates
This question relates to Calculate Total Number Of Days Per Specific Month.
If you look at the original question what IF you have a start and end date Jan - March and you need to know how many days ...
-2
votes
2
answers
118
views
Report the min value from a columns as a reference to another value
I would like to report the minimum value on one cell, so that min value should be from one column and looking from another column.
I did that with the average value but I am not able to do it with ...
-2
votes
1
answer
121
views
IF formula to compare several cells
Having problems with "IF" in Excel.
I want to compare Cell A2 with cells B2, B4, (...), B100 from another sheet.
How do I write the formula?
-2
votes
1
answer
2k
views
MS365, Excel 13 - New row added not auto updating formulas
I have a table in Excel I made myself not an inserted one - though I have tried that too it didn't do anything. The problem is at the end I add a new row and none of my formulas are in the new row. My ...
-2
votes
1
answer
1k
views
Attendence Points Rollover
I have an attendance worksheet where we calculate employee attendance based on points, if employee absent they get 1 point and if tardy or did not complete shift get 1/2 points also if employee has ...