sumif with 2 conditions

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...

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...

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?

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?

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...

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...