Stack Overflow
Stack Overflow

Questions tagged [sumifs]

SUMIFS is an Excel function, introduced with Excel 2007 (v12.0), which allows for the summation of values selected according to several criteria – addition is only of cells meeting all the conditions.

Microsoft describes the syntax so:

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2,criteria2], …)

AbleBits compares SUMIFS and SUMIF and gives examples of usage. Between the two the position of sum_range differs and for SUMIFS each criteria_range must contain the same size (number of rows and columns) as the sum_range argument.

1239 questions
2
votes
0 answers

Add sumifs function to VBA

My current excel workbook consists of stock trading data which is entered into the file at the end of each day. Each day's trading activity is put onto its own individual worksheet, and the columns table layout remain consistent throughout as its…
NHure92
  • 105
  • 2
  • 9
2
votes
1 answer

Excel SUMIFS checking if a column contains text

I have an excel document with data in a PivotTable that is displayed with several subcategories. I need to check if text anywhere in column A contains a particular word and then also check the text in column C to see if it contains a particular…
Daniel Rivera
  • 21
  • 1
2
votes
2 answers

EXCEL SUMIFS IN R using ddply

Im trying to implement a SUMIFS logic for the following table that I have implemented in EXCEL (Column A, B, C respectively): ID x y 123 3 50 123 2 -10 123 4 -20 124 3 50 124 2 -10 124 4 -20 Create a new vector z using the formula:…
Apple_Tree
  • 49
  • 6
2
votes
2 answers

R - Multiple criteria sum across different length data frames

First post, long time user. I'm tryin to efficiently sum a column based on 2 criteria for every ID in another data frame of a different length. Below is an example: ID 1 A 2 B 3 C ID Color Type Price A Green 1 5 A Blue 2 …
BFretti
  • 23
  • 2
2
votes
1 answer

My SUMIFS formula not working correctly

Please can someone advise me where I am going wrong with my SUMIFS formula. Formula worked fine on calculating my outgoing funds however with the incoming it doesn't seem to want to calculate? Your help will greatly be appreciated.
Lee-Ann
  • 21
  • 2
2
votes
1 answer

SUMIF looking at a range of text criteria AND returning blank if empty cell

I have a SUMIF function on one sheet looking at a range of cells in Column A on a separate sheet (EP 1). If the value matches the value in a certain cell in Column A, the SUMIF function sums the numbers in another range of cells in Column D on the…
AnnieMac
  • 21
  • 1
2
votes
1 answer

I'm getting a parse error in googlesheets when using sumifs considering ceratin date range

I have made this work already in another googlesheet, which is why I'm puzzled as to why is not working with this one. I have to sum values from a certain column (sales) by month, therefore, checking the date column and grouping it accordingly…
veronica smith
  • 21
  • 2
2
votes
1 answer

EXCEL: Sum columns based on common index

I'm trying to sum columns that have a common index but the difficulty is that the index is not in the same row. Here is an example DayIndex2018 Value2018 DayIndex2017 Value 2017 empty empty 1 20 1 50…
Laurent
  • 1,465
  • 2
  • 18
  • 41
2
votes
1 answer

EXCEL Formula: Multiply SUMIFS outcome with the corresponding row value from a different column

I am trying to use SUMIFS and multiply its output with the a values from the corresponding row. Example: Example In This example I will use just 1 criteria for the SUMIFS, but the concept remains the same: SUMIFS(C2:C5; B2:B5; "=Sum"). This would…
user9011819
  • 21
  • 1
  • 4
2
votes
2 answers

(MS Excel) How to automatically increment the row of a criteria in the sumifs function if it is enclosed in quotation marks?

This is the function or method: =SUMIFS(sum_range,criteria_range1,criteria1,...) This is my formula that I want to drag down: =SUMIFS(DTR!AE$2:AE$1048576,DTR!B$2:B$1048576,">='Payroll - Extra'!A2",DTR!B$2:B$1048576,"<='Payroll -…
Pherdindy
  • 1,168
  • 7
  • 23
  • 52
2
votes
2 answers

Reference variable worksheet in another workbook in formula SUMIFS using VBA

I am trying to add a SUMIFS formula to cells, whereby I need to have variable which refers to another sheet in another workbook. However, this does not work in my code. FYI, I have already opened the workbook with msoFileDialogFilePicker. Here is…
Vivi Xu
  • 131
  • 2
  • 5
  • 12
2
votes
1 answer

Cumulative Sum from a range identified based on Vlookup

In Excel sheet 1, I have the following data: A B C D E F G ------------------------------ Name1 1 2 3 4 5 6 Name2 2 9 3 8 4 7 Name3 4 6 0 3 2 1 In Excel sheet 2, I have to calculate cumulative sum…
Karthik Sankar
  • 21
  • 1
2
votes
1 answer

Excel VBA SUMIF Run-time error '424': Object Required

This produces an Error: Run-time error '424': Object Required Private Function Y_Mode() As Double Dim MaxGrad As Double MaxGrad = WorksheetFunction.Max(Graduation_Series) Y_Mode = WorksheetFunction.SumIf(Graduation_Series, MaxGrad,…
bravogolfgolf
  • 357
  • 2
  • 11
2
votes
1 answer

Excel SUMIFS Multiple Criteria Cell Value

Similar questions to this have been asked but not exactly like this. There is one that is very close, but that solution is not working for me. I have a function which returns comma separated values into a cell. I would like to pass the elements in…
Nick Criswell
  • 1,733
  • 2
  • 16
  • 32
2
votes
2 answers

Excel - numeric wildcard to aid grouping of values?

I'm using SUMIFS in Excel to add values on the basis of a site name. Currently, I'm using a * wildcard to establish a generic site name so that similar site names are considered together (e.g. London&'*' to group together "London 1" and "London 2").…
sjbka
  • 45
  • 5
1 2 3
…
82 83