In the attached sheet, I have 3 steps:
1- Getting the value by multiplying the daily rate by the value
2- Getting the total value
3- Summing the grand total value by the country
In step 2, I am using SUM, and in step 3, I am using SUMIF to get the grand total by country.
How do I eliminate step 2? I need to SUMIF directly.
What do you think?