Percentage Formula Help

Canteaug · 09/20/24

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 · 09/22/24

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 · 09/25/24

@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 · 09/25/24

@dojones

dojones · 09/26/24

@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 · 10/02/24

@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".