question on SUMIF with multiple criteria

hhap

New Member
Joined
Aug 13, 2002
Messages
5
I have a table in two worksheets(sheet1 and sheet2) in the same workbook. On sheet1, column A holds the data for the range_to_match for SUMIF ;Column B has the second criteria needed and Column C holds the values for the Sum_range. On the second sheet "sheet2", Column B has the data for first criteria which is to be compared with the range_to_match in Column A of sheet1. Column D of sheet2 is where the result is to be output. The data is very huge (10,000 rows). I want a SUMIF or conditional summation formula that can handle multiple criteria such that it takes the first criteria from column B of sheet2 and compares with the range_to_match in coulumn A of sheet1 as well as add the second criteria in column B of sheet1 and then sum all the corresponding values in column C of sheet1 onto column D in sheet2. I need suggestions. If a macro will do I will appreciate it.
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
See the Excel Help topic for "Summarize values that meet conditions by using the Conditional Sum Wizard".
 

Forum statistics

Threads
1,144,769
Messages
5,726,183
Members
422,661
Latest member
foxleinlady

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
Top