SUMIF with condition

Dear Gurus,
Here is a situation I am struggling with:
ACTIVITY Main Main_Type Account Description Period Balance
A0000300 1501 BS Notes Receivable $147,576.40
A0000300 7603 Act Collection Costs $405.66
A0000300 4708 Act Loan Fund Interest ($5.53)
A0000300 4708 Act Loan Fund Interest ($2.41)

On another worksheet, I would like to sum from this table for "ACTIVITY" codes, where the "Main" number is higher than 5000.
So if on the other sheet, there is code A0000300, add up all the amounts where the Main number in this table is above 5000; therefore in this example the sum would be 405.66.

Thank you very much for the help.

Hi Ace,
The SUMIF formula is on a different tab. So the activity code has to be found on that tab looking in a table (see example) on another tab.
Thanks!

Originally Posted by Ace_XL

Try

=SUMIF(Sheet1!B:B,">5000",Sheet1!E:E)

where
- 'Sheet1' is your worksheet with the Data
- Column B on Sheet 1 is 'Main'
- Column E on Sheet 1 contains amounts

Hi Ace,
Let me include part of the worksheets. Maybe I am not explaining it well. I need the SUMIF in Data 1, based on the data in Table 1. So the numbers to be added are looking for the same activity code with corresponding "Main" numbers above "5000".
Thank you again.

Originally Posted by Ace_XL

Need to read stuff thoroughly

Use SUMIFS
=SUMIFS(Sheet1!E:E,Sheet1!A:A,"A0000300",Sheet1!B:B,">5000")

You can also use cell references for A0000300 and >5000