In transaction 1, you received a total 0.032 in 3 different addresses, then you sent it to address D.
In transaction 2, you received the same amount of BTC in 3 different transactions of the same amounts to the same address (E), then you sent it to address F.
Transaction size of tx1 and tx2 are the same, is this correct?
Yes... BUT, only if addresses A, B, C and E were all compressed or uncompressed. If some are compressed and others are uncompressed, then the sizes will be different (not by much, by they will be different).
Also, would this be correct irrespective of the amounts being sent because what matters is the number of inputs on a transaction?
Number of inputs AND number of outputs (but to a lesser extent as they're smaller) affect the data size of a transaction. You are correct that the "value" of BTC has NO affect on the "data" size of the transaction though... so a transaction for $1,000,000.00 could theoretically be "smaller" than a transaction for $10.00
I still don't quite get how size and therefore fees are calculated, and I don't get what you tried to show me there with your blockchain link to be honest.
The simple formula for compressed addresses is this:
Transaction size = (Number of Inputs * 148 bytes) + (Number of Outputs * 34 bytes) + 10 bytes
The simple formula for (older) uncompressed addresses is this:
Transaction size = (Number of Inputs * 180 bytes) + (Number of Outputs * 34 bytes) + 10 bytes
These formulas, will generally calculate the transaction size within an error margin of a few bytes as long as the number of inputs is less than 10
It's basically an +/- margin of about 2 bytes per input. They are also only valid for transactions from "1"-type addresses.
So, in the end, it comes down to some pretty simple maths... work out how many inputs you have, in your example we have 3... and how many outputs... again, using your example we have 1. Let's pretend your wallet is using compressed addresses (most newer wallets tend to use compressed addresses)... so now, we can see:
Transaction Size = (3 * 148) + (1 * 34) + 10
=> 444 + 34 + 10
=> 488 bytes
It might be maybe 6 bytes off... but should be valid for "estimating" a good fee... bitcoinfees.earn.com is saying that "recommended" is 410 sats/byte for "next block" confirmation...
So, 488 * 410 = 200,080 sats => 0.00200080 BTC for a fee... which is about USD$37... I hope you're transacting $1mil and not $10