•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Sum up two cells each of which has separate conditions/criteria.
Our take
Struggling to find the right way to sum two cells based on specific criteria? You’re not alone. In this scenario, where one cell must be greater than or equal to 12 and the other must meet or exceed 40, the solution is straightforward yet powerful. By using the SUMIF function creatively, you can ensure that the sum occurs only when both conditions are met. Keep reading to uncover the exact formula that will streamline your calculations and enhance your spreadsheet efficiency.
Taking place in a single row.
1st cell must be greater than or equal to 12, 2nd cell must be greater than or equal to 40.
Sum the two cells if and only if the above conditions are followed.
I've been looking up various sumif(s) functions and I just can't seem to find a specific formula. I'd appreciate it if I can get some solution.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Is there a way to Sumifs up to a certain column with multiple criteria?Hi everyone, I’m looking for a formula to sum all of the columns starting from a particular column up to a particular column. How do I best do that? On the data tab, Row 1 I have the following columns: A1 = date B1 = serial number C1 = customer name D1 = date 1, with the data being $ E1 = date 2, with the data being $ F1 = date 3, with the data being $ In a separate tab I have the same thing mirroring the data tab, but without the $, for the calculation what I intend to do is on E2, I want to say if $A2 = E$ 1, then sum all of D up to E column on the data tab provided that the value on B column of the data tab match B2 of the calc tab, and C column of the data tab match C2 of the calc tab. For F2, it would be the same thing, but sum column D up to column F instead of column E. I hope it makes sense. Thanks for your help! submitted by /u/botng [link] [comments]
- Sum of a range based on 2 different criteria?Hello, I'm working on a document which is a holiday funds to keep track of individual person's remaining balance to pay. I want to use a formula to automatically calculate the sum of a range of cells which lie against a certain year under a person's name. Below as an example: https://preview.redd.it/1p19n1o8qrxg1.png?width=991&format=png&auto=webp&s=2e67c0337da92ae1feffe43fc2c7fbaba237d672 As above, I want to look up Name 1 in 1:1, look up Year 1 in A:A and then return the sum of those numbers in that Year 1 range to give me my final result. Is this possible? I've tried all sorts of SUM, SUMIF, SUMIFS, XLOOKUP and combinations but can't seem to get it to work. I also don't want to have to manually select the cells for year SUM as this is constantly updating and want it to be automated. Thank you! submitted by /u/celestialspace [link] [comments]
- Philistine needs help creating loop.Updated: Hey everybody - new to excel and doin' my best, but could use your help. Dumbing it down for my own sake, I need to create a function that will check multiple criteria against a static reference, then add corresponding cells together into an eventual sum. https://preview.redd.it/cqfqdsay25og1.png?width=566&format=png&auto=webp&s=d8dca20f059cee8d3c05170fae7c08a09d63ce2d In English: If A2 = red and B2 = sunny and C2 = 20, D2 (+ all other values that passed this same logic test). Move to check next row. Else, move to check next row. Since two of the rows (4 and 6) pass the logic test, the expected outcome would be 20 As a function: That's where you come in... Thanks in advance. To the people saying SUMIFS - Yup! That's probably exactly what I'm looking for, but I said I'd update this to be clearer, so I am. I'm going to look into it a bit and try to understand how to implement it, then I'll mark this solved. Thank you! submitted by /u/Weird-Rich4823 [link] [comments]