All Questions
67
questions
0
votes
0
answers
41
views
Excel: Countif with multiple criteria
Sheets("Create Summary").Range("B3").Value2 = _
Excel.WorksheetFunction.CountIfs( _
wsSourceData.[P:P], "Airports", wsSourceData.[AQ:AQ], "Not completed&...
0
votes
1
answer
131
views
Excel sum formula but with Criteria from multiple tables and columns
I have 3 Sheets / Tables in my Excel...
Table 1 (Master Stock):
Table 2 (SubLocation Rules):
Table 3 (Product Stock Summarize):
The goal in table 3 is To sum the Product Stock on Table 1 but with ...
0
votes
0
answers
56
views
SumIf formula with multiple columns or criterias
Happy Friday,
I need help with a formula.
I want C30:C35 to be the sum of D2:D10 IF the text in B2:B10 Matches the text in A30:A35
So if A30 says "Apples" and B3 and B4 also say "Apples&...
0
votes
2
answers
52
views
Calculating Monthly Orders (Integers) in Given Month From Annual Number (Integer) with Monthly Seasonality
I want to distribute an annual number of orders across 12 months based on certain percentages while ensuring that each month only has whole orders (no fractions). When a fraction of an order ...
0
votes
1
answer
132
views
Sum the values of a cell in Excel or change to a different expression of that value in another cell
I have a cell of a worksheet with a value of
1h 25m
entered with the cell (got it from a Jira import). I am trying to figure out how to populate another cell on the same row with a purely numerical ...
0
votes
0
answers
26
views
How to apply vlookups to a range of cells dynamically within a single cell?
I'm trying to sum numbers which are the result of multiple vlookups in a single cell.
Is there a way to do this dynamically? and more efficiently than I have done now?
MY current formula below is ...
0
votes
1
answer
57
views
Sum if blank leave it empty [closed]
https://i.sstatic.net/5mlnV.png
This picture shows the column H is subtracting column A,C,E. If you look at row no H:11 it shows 0 because there is not data found. What I want to do is leave it empty ...
0
votes
0
answers
71
views
Sum different cell that link to checkbox (if true, then sum the value)
I got a problem to sum the amount in the green box. The thing is, whenever the checkbox ticked (true) then the cell contain an amount will turn to green. I want to make the sum formula only for the ...
0
votes
1
answer
4k
views
Getting SUM for hh:mm:ss in EXCEL
I'm working with a document where I need to get the SUM of various values for time spent on calls and assign/display that value in a totals cell. I've attached an image of the data I'm working with. ...
0
votes
1
answer
185
views
How to find the sum of the first or last number in a range of cells to provide min and max totals?
I hope I can properly describe the problem I'm running into here.
I'm trying to create a formula for the following situation:
I have a spreadsheet that returns a specific dollar range into a cell ...
0
votes
1
answer
294
views
Excel Formula to sum amount found in one list by lookup value found in another list
Looking for an Excel formula to sum amounts by a lookup category found in another list. Think 3 lists in total. Here is the setup.
List1 is Category: Fruit, Vegetable and Amount. The formula goes ...
1
vote
1
answer
75
views
Excel: How to create list of unique elements respect one column?
I have a list like this (small example):
Orig Dest Qty
BEL PL 12
UK PL 45
BEL DNK 32
ESP DNK 22
UK CZE 14
BEL PL 11
UK PL 31
UK CZE 08
I would like to list it like this:
(...
1
vote
1
answer
66
views
Excel is mixing up cell contents when using SUM and SUMIF
I might be misunderstanding how Excel's SUM and SUMIF functions work. I'm using the formula =SUM(SUMIF(OctDSPB,"70",OctDYen),SUMIF(OctDSPB,"80",OctDYen),SUMIF(OctDSPB,"90&...
0
votes
3
answers
493
views
Excel Formula - SUM LEFT on non-blank cells
In the following table at column E, I'm trying to extract the number before parentheses (which is 4 and 5 here) and then return the total summation on extracted values (which is 4 + 5 = 9 here)
The ...
0
votes
1
answer
325
views
Best way to get column totals on multiple columns with varying row sizes using MS Excel VBA
I have hundreds of columns (fixed) and a varying number of rows depending on the data pull. I have a code which inputs a totals formula in last row plus one. This works well. But I have so many ...