the sumif function will do this very easily - oir you can use sumproduct. I personally find the sumif approach more "approachable" i.e. I can read the formula very easily - and my poor little brain manages to follow. The sumproduct is probably the clever and more effecient way to go - just try doing a search on sumproduct on this site and you will see lots of examples - however I suspect someone will be along shortly....
you can lookup the sumif function in the Excel help as this is its intended purpose and the doc will explain all. Sumproduct - well I found these which I think are what you need:
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.