Percentage Formula Help

Canteaug

Hi,

I am trying to pull the percentage of multiple categories for several counties. For example, There is one column that is a dropdown column that lists all counties and we report if there specific errors associated with the county. I am trying to pull the percentage of each error for each county. Can someone please help?

dojones

Create a County Summary sheet to gather the data.

As an example, if this is the data set.

The County Summary sheet would be

Where

County: List of all counties

Fault%:

=IFERROR([Error Count]@row / Total@row, 0)

Total: Total times County appears in list

=COUNTIF({County Data Range County}, County@row)

Error Count: Total times Fault of Error is entered

=COUNTIFS({County Data Range County}, County@row, {County Data Range Fault of Error}, ISTEXT(@cell ))

Canteaug

@dojones thank you for your help! I did try the last formula and it says unparseable. Do you know why that would be?

=COUNTIFS({State Office SNAP QC Review Range 1}, [County ]@row, {State Office SNAP QC Review Range 4}, Agency Error(@cell ))

Canteaug

@dojones

dojones

@Canteaug

I don't think Agency Error is a column in your sheet. It should be [Fault of Error]. If you do have an Agency Error column name in the sheet, then it should be bracketed [Agency Error]

Canteaug

@dojones Agency Error and Client Error are the dropdown names and Fault of Error is the column name. Both formulas work until I enter the percentage formula. It throughs the error "blocked".

dojones

Add the brackets around Agency Error i.e [Agency Error]

=COUNTIFS({State Office SNAP QC Review Range 1}, [County ]@row, {State Office SNAP QC Review Range 4}, [Agency Error](@cell ))

Canteaug

it's throwing the error unparseable now. I tried retyping the whole thing as well. @dojones

dojones

My mistake. Agency Error being a dropdown can't be in the formula. It has to be [Fault of Error]

Did you create a County Summary Sheet?

In main sheet, Fault of Error should not be a formula, it's the error reason. The Percentage Formula has to be in the County Summary Sheet.

Canteaug

@dojones Thank you so much! That worked!