I've got 2 columns and at the bottom a total weighted average for the 2 columns.

So for example the formula is Sum(Field2 * Field3) / Sum(Field2)

This is raw data I copied form a report:

A1 A2 A3 A4
--------------------------
Field1 Field2 Field3
1 T 1,235 32
2 U 3,327 7
3 T 3332 5
4 U 22333 10
--------------------------
Wt avg T Sum(Field3 * Field2) / Sum(Field2) (where Field3 relates to the T Field3 values only)
Wt avg U Sum(Field3 * Field2) / Sum(Field2) (where Field3 relates to the U Field3 values only)

I'm not an Excel user much so I was thinking I could create a new column(A5) with a formula that would take Field 3 * Field 2 and then in my Wt Avg at the end just do a Sum(A5) / Sum(A3) or something

but that seems too much work, there has to be an easier way to get that calc in for my wt avg totals at the bottom using one formula right? I don't know how to code that formula...and again the two totals are dependent on T vs. U rows