sumifs

  1. S

    SUMIFS based on text criteria between selected dates

    =SUMIFS($K$17:$L$1000,$G$17:$G$1000,"win**",$B$17:$B$1000,">="&$R$663,$B$17:$B$1000,"<="&$R$664) K:L range I want to sum in [h]:mm G Text condition B date range. I can select dates in R663 and R664 I have tried the text condition (G) at the end but both returns #VALUE!. Where have I gone...
  2. L

    SUMIFS/INDEX-MATCH based on criteria in 2 rows and 1 column

    I'm using Google Sheets. In another tab, I'm trying to match in the values (in the white part of the table) based on the three criteria. So for example, I'm wanting to match in the 0.2856... for criteria: Member #1, 1, A.
  3. L

    SUMIFS with 2 row and 1 column Google sheets

    I'm trying to match in a value (either using SUMIFS or INDEX MATCH) based on multiple criteria (two rows, one column).
  4. D

    sumif or sumifs with concatenated values

    Hello folks, I have problem in collating the results from table. Following is the data i have . Here i need to combine the count for test names and test names(failed). i.e., I need to take and collate Blue and Blue(Failed). However this shouldn't include "Blue ocean" entities. Test runs...
  5. F

    HOW TO USE SUMPRODUCT, SUMIFS AND INDIRECT TOGETHER

    I have 12 sheets that needs to be summarises based on months and withdrawals and item codes. so i created a range name and named it Donors I then proceeded to use this formulae. however, the answer ends up being #ref! I8:I200 has the withdrawals, D8:D200 has the months, Table13[[#Headers],[Jan]]...
  6. J

    HELP - Complex SUMIF - SUM of PRODUCTS of two cells IF another cell is within a specified date range

    Hi all, I am new to this forum and so apologise if I have posted this to the incorrect thread, etc. What I am trying to do is quite simple in theory, but I cannot get a variation of SUMIFS, SUM and IF to do the job. The context is this: I am looking to create a resource for a client couple...
  7. C

    Sumif(s) with OR criteria in multiple columns

    Hi everyone. I am trying to write a SUMIF() formula that pulls in a total from one column if either one of two other columns is greater than zero. Value1 Value2 Value3 500 0 1000 0 200 2000 100 100 5000 0 0 4000 So my psuedo code would be: If value1>0 OR value2>0 SUM...
  8. M

    SUMIFS with multiple criteria multiple columns

    I need to write an excel function to find total recorded cars based on Region and Direction Please consider that I can ONLY use Sum, Sumif, and Sumifs and i can't use Use SUMPRODUCT or if.
  9. L

    Reference to a specific 2 cells

    Hi, I have sales for Target product A, B, C, D and then sales for Amazon product A, B, Walmart product A, D. How do I calculate what were the percentage of sales for each customer/product referring to Target/ specific product? Thank you in advance. Lena
  10. A

    VBA SumIfs return both 0s and correct results

    So I have a piece of codes using SumIfs to return Quarterly Totals, breakdown by Quarter and Yearly Total, breakdown by year. However, The Yearly Total, Q1 Total,Q1 breakdown, Q2 Total, Q2 breakdowns return correct results while Q3 and Q4 breakdowns all have 0s, even though Q3 and Q4 Totals...
  11. L

    SUMIFs, SUMPRODUCT, and INDIRECT

    Good Day, I am trying to solve this issue, but I didn't find any mistake in the formula. Could someone please help me check or correct the formula? Thank you You can check the file in this link: TEST FORMULA.xlsx 😁😁😁
  12. H

    SUMIFS VBA Code on multiple worksheets

    Hi All, I would like to know on how to write VBA code for SUMIFS on multiple worksheets. Right now I am using SUMIFS but my data is more than 60000 Rows and using the function SUMIFS is very slow. I need a VBA code to extract the data from worksheet 1 and into the rest of the worksheets by...
  13. P

    Consider first occurrence while using SUMIFS

    Following table data is my challenge. Can anyone help me to resolve this. I need two formula that can 1. Return -5000 on the first line using criteria company, code and month in a cell and 2. Return -5000 on the second line using the same criteria mentioned above in another cell Sometimes...
  14. D

    Extracting Data From SUMIFS

    Okay so on a pivot table if you double click a search result you get a new sheet showing the results. I am wondering if there is a method to replicate this from data returned by a sumifs formula?
  15. C

    SUMIFS with IF and AND functionality

    Team, the code and formulas i have typed into a few of my cells trying to figure this out has turned into a monster i have lost control of. Details are below. This spreadsheet is used to summarize overtime for everyone on a shift for a single day. Column F gets numbers manually entered. Column...
  16. R

    Fancy sumproduct / index lookup

    Hi, Apologies for not uploading a workbook - company restrictions prevent me from this However, I need to consolidate the employee data in table 2 at the very bottom and present it as per table 1 below this message. the main issue I'm encountering is that the pay category runs across the row...
  17. A

    IFS with addition? Help Please

    I am looking for a formula that will add 180 days to G3 if the answer to E3 is NO with the result put in H3, if the answer is yes put the date in F3 with the result put in H3. I have uploaded a screen shot for reference. Thank you for your help!!
  18. C

    Formula returns error and don't know why

    Hi The below formula return #VALUE and i'm not sure why =SUMIFS(INDIRECT("'"&$B$1&"'!$b4:$n17"),INDIRECT("'"&$B$1&"'!$a4:$A17"),$A7,INDIRECT("'"&$B$1&"'!$b2:$n2"),">="&$B2,INDIRECT("'"&$B$1&"'!$b2:$n2"),"<="&$B3) I have tried the below alternative and get #REF...
  19. T

    SUMIFS-like Formula to grab text AND numbers

    Hello - I need a formula that will work in a matrix - I have been using SUMIFS to populate my worksheet. I need a non-array formula (too slow) that can handle multiple criteria that can pull both text and numbers. One criterion in the SUMIFS is a column and the corresponding array are rows...
  20. X

    Sumifs within an Array?

    Is it possible to do a sumifs within an array? I have a large data set (circa 20,000 rows) that I am working on and one of the elements is a sumifs. Currently I'm creating most of the array, pasting it to a sheet, and then updating the remainder of the array by running the sumifs on the sheet...

Some videos you may like

This Week's Hot Topics

Top