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
3 answers

Excel SUMIF equivalent in Pandas

import pandas as pd import numpy as np df = pd.DataFrame([['A', 201901, 10, 201801, 201801], ['B', 201902, 11, 201801, 201802], ['B', 201903, 13, 201801, 201803], ['B', 201905, 18, 201801,…
Barry
  • 185
  • 1
  • 3
  • 10
2
votes
2 answers

SUMIF: formula as criteria not working for entire column

My worksheet contains orders from clients. The orders are all wooden panels. Every order is assigned a number which is led by the letter Q. Column B contains the number of parts in the order. Column C contains the total m² in the order. Orders…
BRTN
  • 31
  • 4
2
votes
1 answer

Excel - SUMIF Function

I made a worksheet covering meal expenses for a set period of time (01-08-2020 until 31-08-2020.) The company will pay up to 75kr, Monday-Friday. The list covers expenses 7 days a week, If the amount is greater than 75 on Monday-Friday, I have to…
Mikal Mian
  • 21
  • 1
2
votes
3 answers

How to sum specific information w/ multiple criteria including dates from form submission

I have a sheet that is linked to a google form so when a person submits the form, the information is populated into the sheet automatically with a timestamp, ex.1/17/2020 17:26:16. I'm trying to sum information based on multiple criteria and one is…
Emily Prior
  • 35
  • 3
2
votes
1 answer

SUMIF in Google Sheets for a month and if a column contains text

I have some simple data in the following format: I need to make a sum of the last column, but based on the text in Domain column. The resulting table should be like this...given the text filtering needed, I'm not using pivot tables. To do this,…
Khom Nazid
  • 548
  • 1
  • 7
  • 20
2
votes
1 answer

array based sumif in excel by formula

So I m trying to find some alternative to sumifs in excel where each condition needs to be checked in a 2D range instead of a 1D range. For example, in the below table I want the sum of values in column V for rows where A12 ("IJ") is present in…
LOKE2707
  • 312
  • 1
  • 5
  • 19
2
votes
1 answer

vba sumifs multiple criteria in single column

lets say I have in columns A and B this: A 5 A_1 3 A_2 2 A_3 3 A_4 4 and i want to do: Application.SumIfs(range("b:b"), range("b:b"), {"A", "A_2"}) however this doesnt work, the array values. I wish not to go through EVALUATION() (or []…
Jiri Zaloudek
  • 326
  • 3
  • 19
2
votes
0 answers

Excel: Adding a Criteria Check into a Countifs dynamically, based on the contents of another cell

First time asking, long time reading! Any help would be much appreciated. I have an excel sheet with two cells that contain values from a drop down list - let's call these condition1Cell and condition2Cell. The options available in the drop downs…
George Fairfield
  • 21
  • 3
2
votes
1 answer

Google Sheets: How to sum multiple unique criteria

I'm trying to pull only the "Travel" info from this table and sum the unique values based on multiple criteria. For example I want all Uber expenses grouped by Department and Credit Card and have all the Amounts that are in the same department and…
Vekin0
  • 83
  • 2
  • 11
2
votes
1 answer

excel extendable formula for conditional sums over multiple columns

I have an arbitrary number of columns, one for each period a course is offered, in chronological order, and an arbitrary number of rows, one for each unique participant. The values are '1' for participation in that month, '0' for…
Garth Yule
  • 55
  • 5
2
votes
3 answers

SUMIF function multiple references

How can i use the sumif function on multiple references. GROUP COLOUR TOTAL GROUP A BLUE 50 GROUP A BLUE 100 GROUP A GREEN 25 GROUP A YELLOW 50 GROUP A GREEN 35 GROUP B GREEN 45 GROUP B RED 30 GROUP B RED 5 GROUP B BLUE 7 GROUP A…
liamrichards479
  • 23
  • 2
2
votes
1 answer

How to sum a row in google sheets without taking the Nth column (N depending on the row number)?

I'm currently trying to sum some numbers in a single row, but they can't sum a number where the column number + N equals the row number. This is my current sheet (it is not completed yet): Current sheet The darker column needs to sum the row to its…
LeoVen
  • 632
  • 8
  • 18
2
votes
3 answers

SUMIFS with moving criteria

My excel worksheet looks something like this: Worksheet: What I would like to do is to sum all of Bob's X1 values that are larger than the X2, X3 and X4 values on their respective row. So, in this case, 5 + 14 + 15 = 34, as the other X1 values of…
vladi98
  • 141
  • 7
2
votes
1 answer

Excel Index and Match Sumifs with multiple rows and variable number of columns

I am working on finding the sum of values in a data table with a variable number of rows for each value and a defined number of columns. The formula below works to sum the rows in the data table based upon a single column but I cannot see how to sum…
AlanB
  • 83
  • 1
  • 2
  • 15
2
votes
1 answer

Sumif with staggered columns

I would like to add the rows if the value in each cell is less than 100 and if the columns headings were "Tom", "Dick" and "Harry" So in Row 1, only Dick is less than 100 so the sum is 7. In Row 2, Tom and Harry are less than 100 individually so the…
Amatya
  • 1,203
  • 6
  • 32
  • 52
1 2 3
…
82 83