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
1 answer

Calculate the volume sold from all sheets and then assign it to the corresponding district of the summary page

I need data to be shown in B2:B100 of a summary page. The data should be pulled from nine other worksheets, to calculate the volume sold from all sheets and then assign it to the corresponding district of the summary page. It should be done once the…
David
  • 1
-2
votes
2 answers

Excel: Sum column B if left(A:A,2) ="ZZ" and right(A:A,2)="CA" and mid(A:A,3,1)=4

I'm trying to sum values in column B if: First 2 charactersin column A = "ZZ" Last 2 characters column A = "CA" 3rd character in column A = 4 Tried using sumproduct but no sucess!
Seva
  • 57
  • 10
-2
votes
2 answers

Google Spreadsheet SUMIFs equivalent

I need a SUMIFs equivelent in google spreadsheet. It only has SUMIF, no IFS. here is my data: # Salesman Term (Month) Amount 1 Bob 1 1,717.09 2 John 1 634.67 3 Bob 1 50.00 4 Bob …
M. of CA
  • 1,496
  • 2
  • 22
  • 32
-2
votes
1 answer

Excel How to calculate SUM of specific condition

I want to calculate SUM in specific condition in online excel sheet For example: Oct James DONE 2 Oct Michel DONE 5 Oct James DONE 2 Oct James Pending 1 Now I want calculate hours of only James work with DONE status (Not Pending…
MMaggy
  • 42
  • 1
  • 4
-3
votes
1 answer

SUMIFS formula by date

I am trying to use SUMIFS to filter my data and provide averages using the month and year stock name as criteria. I have attached a screenshot below. So, if stock CKK in column A traded 5 times in 2018, I'd like a sum total of that figure in column…
NHure92
  • 105
  • 2
  • 9
-4
votes
1 answer

Replicate sumif formula in python

I am performing a sumifs operation in Excel and would need to replicate the same in Python. Column 'E' in the below screenshot is my end requirement. For example, In AMS Territory: Product 1 Sales is 100K however upon adjustment it changes to…
SASguru
  • 17
  • 5
-4
votes
1 answer

How to count sum of items, without summing duplicates, for 2 conditions

Related to the attached spreadsheet, (I have already created a dashboard that contains the list of regions) Count the number of unique Items for each region IF Item Category equals N/B/C/H/P Sum of the prices of the unique items for each region IF…
Mystic-1
  • 3
  • 1
  • 3
-5
votes
1 answer

SUMIFS Function in Excel returning "too many arguments"

I encountered the "too many arguments" error when trying to calculate the total sum of values from column C if the following criteria are met: When F is equals B When E is larger or equals to D (to minus 1 from current year and keep month and day…
Yi Xian Soh
  • 1
  • 1
-5
votes
1 answer

Issues using sumifs() in VBA

I'm trying to basically translate a formula from excel into VBA. I'm using the SUMIFS() command and I have it referring to columns in an already established table. This is what I have so far but I keep getting an object error. Cells(2, 14).Value =…
PMac
  • 11
  • 4
1 2 3
…
82
83