Dynamic Count and Sum Array Formulas Based on Multiple Conditions

Guys,

I looking for a Dynamic Count and Sum array formulas to count and sum the unique values based on 2 conditions similar to what the Remove Duplicates Function in the Excel Ribbon. Col. B will contain number values only and Col. C will contain Text & Numeric combined.

Both array formulas should adjust to variable ranges. Each formula should be placed in its corresponding
cell as highlighted in yellow. Attached is the XL file as an example.

Highlighted in yellow is what the result of the dynamic count and sum array formulas should return as the answer.

Thank you,

Thanks Guys,

Both of your posts are awesome Thank you so much!. I can definitely utilize both options for my future projects.

Now, before I close this thread, any ideas on how to make the ranges on each of these options dynamic where the ranges will expand and retract in accordance to the variable rows of data?

For instance, can the Rows function or a Name range with another formula function embedded in it of some sort be used somehow to return the required adjusted range into the formulas?

Works perfect! Thanks guys.

I have a much simpler question - but this is the closest thread I could find.

I think my question is about Variable Ranges in a Formula.

I take several motorcycle trips every summer, ranging in length to 60 days.
Rows for each of 60 potential Days, and lots of Columns for stuff like miles, rain, hours, etc

below the 60th Day/Row are rows of formulae for Each Column like Min, Average, Max, etc

For a short 10 day trip - I just fill in the data on the top 10 rows and IGNORE the rest of the rows.
So I have to edit the formulae for the Last Day/Row Number so they only include the relevant 10 days.
(lots of complex reasons, not evident in this simplification, why just deleting the unused rows will not work.)
For example: =AVERAGE(B1:B10)

I want to just change one cell value (in this example to 10) and thus all formulae would calculate rows 1 thru 10.

For example:

=AVERAGE(B1:B,MysteryFormula(cell-address-with-Last-Row-Number))

everything I try keeps return text not address
and, of course, B and MysteryFormula have to be combined into an Address

thanks, Bob