sum a column based on another column

  1. SanjayGMusafir

    Filtering Dates within the dates and adding corresponding values

    Hi Experts Got stuck up in a strange situation. Tried copying XL2BB from original file - It failed. So copied the actual data to a blank worksheet to explain a situation. What I need to do - Filter dates based on Financial year (April 1 to March 31 - in India) - May see the blue highlighted...
  2. A

    sumifs from week number to Month

    Hello, i have below week wise upcoming shipment data in a sheet Week No Part No 18 19 20 21 22 23 24 25 A 41 0 18 85 42 81 0 49 B 0 3 55 0 17 0 73 0 C 34 9 5 54 29 0 92 0 D 59 20 0 31 27 20 98 26 and i need monthly total in another sheet. for example i...
  3. A

    Sum with multiple conditions

    Hello Experts, i need to plan my purchase requirements , we have a multilevel Bill of materials & few components are manufactured inhouse , few are from external vendors , our vendor base is also global.. few components are common for more than 1 finished goods.. some components are required to...
  4. A

    sum formula

    Hello Experts, i have below data Part Num Date Issue Qty ABC 01-01-2024 7962 XYZ 02-01-2024 2938 ABC 03-01-2024 430 ABC 04-01-2024 1832 ABC 05-01-2024 9413 ABC 06-01-2024 9759 XYZ 07-01-2024 8676 XYZ 08-01-2024 147 XYZ 09-01-2024 5097 XYZ 10-01-2024 9240 XYZ 11-01-2024...
  5. Wellness

    SUM cells in a column >0 based on the month and year of another column

    Hello all, I am currently stuck on what is proving to be a complicated formula...I fear Ive been trying to many things to where now my brain is spaghetti lol. *NOTE* Im using excel via outlook email, I dont actually have excel on my device so I couldnt use the minisheet file. I tried, SORRY...

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.
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.
Go back
Back
Top