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

Iterating conditional sums in R

I have a series of two-dimensional numerical matrices comprising 1s and 0s. (So I suppose they can also be seen as logical arrays.) What I want to be able to do for such arrays is to generate a vector the length of one dimension of the array (the…
Vincent
  • 31
  • 4
2
votes
2 answers

SQL and Excel Sumifs conditions

The best way to start off this question is with a specific Example There are only three distinct claim numbers. Is there a way to sum up the billed amount for claims containing a revenue code 320 and 300 without summing up claims with revenue code…
Kevin K
  • 35
  • 6
2
votes
1 answer

SUM(IF) only finds first value in an array, sometimes

I've got an excel spreadsheet with 2 sheets, sheet1 is an export from a sharepoint timesheet system, sheet2 is to be used for reporting purposes, mainly showing a breakdown of time on a week by week basis. I need a formula which SUM the hours…
Curtis Elliott
  • 59
  • 1
  • 8
2
votes
1 answer

Total (Sum?) with VLOOKUP

I have my clients on one sheet and their bought items. On the sheet where I have my client names, I want to have their total. My code will only "sum" the first cell it encounters that matches the vlookup, it will not add all the cells together…
Hypenate
  • 1,907
  • 3
  • 22
  • 38
2
votes
1 answer

Excel SUMIF with exact word but not case sensitive match

I have a simplified table for this problem example Column A       |  Column B  |  Column C war            | 1          | war War            | 2 warred         | 3 war and peace  | 4 awful war      | 5 dead war horse | 6 Now I need to find…
karjuuhin
  • 57
  • 1
  • 6
2
votes
1 answer

Sum column X based on value in column Y not being in array Z

To keep things simple I have 3 columns (place holders used) X - Contains Revenue Y - Contains a number (hotel room number) Z - Independent list of numbers (room numbers belonging to a certain category) I'm trying to tally all the revenue in column X…
pita
  • 59
  • 1
  • 7
2
votes
3 answers

Turn SUMIFS into SUMIF

I am trying to simplify a SUMIFS formula by using a list of criteria in a SUMIF function. However, my SUMIF formula only seems to consider the first criteria. What am I missing? Please see image and formulas…
gmorissette
  • 291
  • 1
  • 3
  • 13
2
votes
3 answers

Excel - SUMIFS for multiple columns

I need to sum the values of several columns, if other cells in the same row match a predefined criteria. The working formula for only 3 columns is the following: =SUM(SUMIFS(‘Sheet1'!W:W;…
Trenera
  • 1,435
  • 7
  • 29
  • 44
2
votes
1 answer

Excel SUMIFS which adds values if column a, or column b contains a specified value

I've had a look around and can't find a solution, and I don't even know if this is possible. I have two worksheets. I would like Sheet1!G5 to display the sum of values in Sheet2!D:D where Sheet2!A:A OR Sheet2!B:B is equal to Sheet1!D5. I know its…
GiANTOnFire
  • 193
  • 1
  • 4
  • 16
2
votes
2 answers

How can I put together a SUMIFS in Excel to include an OR?

I'm trying to put together a calendar of regular payments which will have a date begun, day the money is paid and the date cancelled (if there is one), however I'm struggling with setting up my SUMIFS function. I've set up an example here. What…
Laurengineer
  • 737
  • 1
  • 9
  • 26
2
votes
2 answers

SUMIF contains one of elements in array (OR)

I have a list of payments where I would like to sum up the costs which description equals to one of the elements in my array. EMTE € 120,00 Bread € 35,24 Lidl € 0,89 Plus € 5,19 Aldi € 2,29 Jumbo € 4,70 So with an array…
Michiel Krol
  • 23
  • 3
2
votes
1 answer

xlsxwriter: Functions VLOOKUP, SUMIF shows #NAME? error

I am working with a python script which uses xlsxwriter for generating a MS Excel file on the fly. I have now almost finished my task by now struck at function error in the generated Excel file. The functions VLOOKUP and SUMIF were converted wrongly…
Jagath
  • 328
  • 5
  • 19
2
votes
2 answers

R how to do the partial row sums

I am very new to R, and I sincerely appreciate your help. The following is part of my data: subjectID A B C D E F G H I J S001 1 1 1 1 1 0 0 S002 1 1 1 0 0 0 0 I want to sum the rows from A to J, and so the data will look like…
Alicia Chang
  • 73
  • 1
  • 5
2
votes
1 answer

Why does SumIf returns 0 with Double and returns true with integer in VBA?

The below is a simple SumIf calculation where I want to sumif >= the variable k that is declared as a Double. This, however returns 0. If I change k for any integer, 3, 4 etc, it returns the true value. But if I change k for 4.23983 it returns 0. I…
molotowski
  • 21
  • 1
2
votes
1 answer

SumIf certain values are in a range

I want to sum up all values that go for a certain country. I tried: =SUMIF(B2:B7;D2=$A$2:$A$7) However, I get 0 back as seen in the picture below. Any recommendations what I am doing wrong?
Carol.Kar
  • 4,581
  • 36
  • 131
  • 264
1 2 3
…
82 83