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...
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.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
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
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
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.