# sumif with 2 conditions

1. ### Summing two ranges but only including the positive numbers

I have two ranges of numbers that I want to get certain numbers from. When they are summed, some come out as positive numbers, and some negative. I want to collect and sum all the positives together, and all of the negatives together. I know I can do this in multiple steps, but I want to see if...
2. ### Special Conditional Sum

Column A Column B Apple-Red 10 Apple-Green 10 Apple- Yellow 10 Orange-Navel 5 Orange-Tangelo 7 Grape-Purple 30 Grape-Green 30 I want to sum Column B if Colum A contains Apple...
3. ### Multiple Criteria for SUMIF

I need to write a formula that sums info where the customer in column A matches another field and the amount in column B is >0. I've found lots of variations of these types of formulas, but none of them are working. Can someone help?
4. ### SUMIF with 2 conditions

I want to calculate a sumif statement in a spreadsheet but I want to have two sets of conditions. It must match what is in one cell and then another. Can you help?
5. ### XL07 Referencing table coloumn values in sumif statements

Hi- I was hoping somebody would be able to help me with a problem I'm having. I want to reference a table of events that lists the dates,the event type and benefits. Currently I have a working sumif that uses dates to retrieve values from a benefit column within a table, however, I need to add...
6. ### SUM(IF...(IF...(IF.... question

I am trying to sum a column based on multiple criteria... specifically a column of time (hh:mm:ss) IF the value is greater than 00:30:00 + IF the value in another column (same row) matches a specific text value in another cell + IF the value in another column matches the date... (I hope I...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back