Attempting to add similar values with Sumif
I have a sheet that could list the same values multiple times as they are being populated via a Zap from Google Sheets. So that I can find a true total value of the Job Name, I am counting the times that they appear on the sheet and then dividing the Total Amounts of Sale for a Job by the number of instances on the sheet, see Average Sales Value. But it gets complex because I also need to add an average sale of Change Orders together with the original Job Name, i.e. Ye[Job #1887] and Ye[Job #1887] CO2. I am stuck on how to add the two averages together to get a grand total for the job.
So, for instance, I want to add the Average Sale Value of rows 7 and 8. I am stuck.
Help Article Resources
Check out the Formula Handbook template!