Formula calculation to find percentage calculation of one location from 5 different locations which

VPMO

Formula calculation to find percentage calculation of one location from 5 different locations which are not older than last 30 days, which shows the result as "#Unparseable "

=ROUND(COUNTIF(City:City, "A") / (COUNTIF(City:City, "A") + COUNTIF(City:City, "B") + COUNTIF(City:City, "C") + COUNTIF(City:City, "D") + COUNTIF(City:City, "E") + COUNTIF(City:City, "F")) * 100, 2 ,(Reported:Reported, >=TODAY(-30)),

Philip Robbins

Ignoring the ROUND function, I think what you're looking for is:

=COUNTIFS(City:City,"A",Reported:Reported,>=TODAY(-30))/COUNTIFS(City:City,OR(@cell="A",@cell="B",@cell="C",@cell="D",@cell="E"),Reported:Reported,>=TODAY(-30))

VPMO

I will try it out. Thanks Philip!!