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

convert string to float inside a SUMIF function

I'm using the SUMIF function except that the column I'm trying to sum is a string like this: "AU $12.3" instead of just "12", how can I strip this string to just return the float value inside my SUMIF statement (in the E…
Finger twist
  • 3,546
  • 9
  • 42
  • 52
-2
votes
1 answer

Google Sheets Sum a column if start date or start date + multiple of frequency column

I have 5 Columns in google sheets A - Date, shows every days date for 365 days in 2023 (snipped to 15 here) B - Where the calculations will go C - $ Amount D - Start Date E - Frequency in Days Column B needs to contain a sum of all values in column…
Christopher Allan
  • 1
  • 1
-2
votes
1 answer

SUMIFS in Power BI

I need to create 2 SUMIFS columns in Power Bi with multiple criteria. One column will be "Per Charge Per month" to find the total charges with "Sum of Charge Amount", "charge bucket", "Type", and "Delivery Month Column" columns as criteria. The…
Spen820
  • 3
  • 1
  • 3
-2
votes
1 answer

Dataframe with start & end date to daily data

I am trying to convert below data on daily basis based on range available in start_date & end_date_ column. to this output (sum):
gray
  • 17
  • 2
-2
votes
1 answer

Sumifs in VBA with multiple criteria in one column

How to sum up year 2011 to 2016 with filter "Company" as AAA * CCC; filter "Include or not" as 1; LOB as EC & PL in VBA coding? n1 = Application.CountA(company) n2 = Application.CountA(LOB) prem = 0 For j = 1 To n2 For i = 1 To n1 …
711
  • 11
  • 2
-2
votes
1 answer

Sumifs with VBA

I have attempted using different VBA subs to pull data from my [MasterRenamed] datasheet into my [P&L] sheet using Category, and date ranges. While I got the first to work, I was unable to figure out how to make it dynamic (i.e. I could only do…
J Armstrong
  • 31
  • 4
-2
votes
1 answer

Excel- Sum groups of similar cell contents using wildcards

I am trying to sum the amounts in column B based on the types of symbols in column A. Any symbol with "EW" at the start needs to be grouped and by date month - see column D. The second symbol comes in two formats but also needs to be grouped, so…
Rich Stevens
  • 599
  • 4
  • 17
-2
votes
2 answers

Google sheets - Sum of values in excel with condition

Considering this scenario with an example I require Excel function that provides a solution for the following problem Column A and B have the following entries. D has the unique values of column A A B C D E 1 x 10 x …
Sylvester Das
  • 109
  • 8
-2
votes
1 answer

Sum by month in Google Sheet

I have question about one function that i require in Google Sheets. I have a schedule of visitors and another sheet that includes every statistic data. I need to make a table which will contain sum of number, but statistic must be by month. In my…
daniktl
  • 63
  • 3
-2
votes
1 answer

Index Match SumIF Problems

I'm trying to create a formula that sums student attendance by week, based on the students ID number. Basically, I want it to look up the student ID, and then output the sum of attendance for certain weeks. This is what I came up with, but it's not…
ME_
  • 1
-2
votes
1 answer

SUM different ranges with multiple conditions

I have offers from many suppliers and I have to chose acceptable offers by different conditions. In H5 I have "p" next to total sum of 61.900,00 in G5. The problem is that I have to separate total sum in G5 by conditions from E1 to E4. That means I…
Miodrag Stefanović
  • 1
  • 1
-2
votes
1 answer

Sumifs outputting blank cells as zero

I am trying to use a sumifs statement to sum a column over 2 criteria. The column I am summing over has blank cells. The sumifs statement returns a zero for these instances, and I want it to return blank. Some of the sums are actually equal to zero…
Rachel
  • 1
-2
votes
1 answer

Excel SUMIFS Formula

I am using the Excel SUMIFS formulas to look for certain item numbers and add that value to the sum. The issue I am having is that many of our item numbers are very close to each other, i.e. 52000135890001 & 52000135890002. The issue I am having is…
Kyle Ferguson
  • 1
-2
votes
2 answers

SUMIFS Formula not working correctly

I have a SUMIFS formula below and it does not seem to be working correctly any help would be greatly appreciated. The formula is below =SUMIFS(C4:N4,C4:N4,C4<=11,C4:N4,F4<=1,C4:N4,I4<=1,C4:N4,L4<=1) From the picture you can see that the result in…
Philip Connell
  • 651
  • 5
  • 25
  • 53
-2
votes
1 answer

Excel: Subtract 2 values based on multiple criteria to get message response rate

Hi I'm trying to track the response rates in various message threads and am having trouble writing the formula. I included a link to a sample data set as well as the sudo formula below. Any help would be GREATLY appreciated! Data Set…
Jeremy Loya
  • 1
  • 2
1 2 3
…
82
83