Trying to filter my results in my table but for some reason when I filter by month all of my % columns give me the total not the individual month total.
This is the formula for the TOTAL column. =AVERAGEIF(J4:J15,"<>0")
When I filter by month I just want to have the total of the month not the entire year. Any suggestions?
This is the formula for the TOTAL column. =AVERAGEIF(J4:J15,"<>0")
When I filter by month I just want to have the total of the month not the entire year. Any suggestions?