SOLVED

Request for Formula Help #VALUE

%3CLINGO-SUB%20id%3D%22lingo-sub-2750971%22%20slang%3D%22en-US%22%3ERequest%20for%20Formula%20Help%20%23VALUE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2750971%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jberlin_0-1631659639306.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310438i98D292BC33141CEE%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jberlin_0-1631659639306.png%22%20alt%3D%22jberlin_0-1631659639306.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHi%20there%2C%20I%20am%20trying%20to%20count%20the%20total%20%22reds%22%2F%20total%20%22whites%22...%20counts%20are%20listed%20in%20column%20E.%20Any%20assistance%20is%20greatly%20appreciated!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2750971%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2751090%22%20slang%3D%22en-US%22%3ERe%3A%20Request%20for%20Formula%20Help%20%23VALUE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2751090%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F505572%22%20target%3D%22_blank%22%3E%40jberlin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20are%20not%20using%20best%20practices.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Convert%20the%20list%20to%20an%20Excel%20table%20(CTRL-T).%20No%20blank%20rows%2Fcolumns.%20Rename%20the%20table%20with%20a%20proper%20name.%3C%2FP%3E%3CP%3E2.%20Insert%20a%20pivot%20table%3A%20%22Red%20or%20white%22%20in%20rows%20area%20and%20%22Count%22%20in%20values%20area.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

jberlin_0-1631659639306.png

Hi there, I am trying to count the total "reds"/ total "whites"... counts are listed in column E. Any assistance is greatly appreciated! 

1 Reply
best response confirmed by jberlin (Occasional Contributor)
Solution

@jberlin 

You are not using best practices.

 

1. Convert the list to an Excel table (CTRL-T). No blank rows/columns. Rename the table with a proper name.

2. Insert a pivot table: "Red or white" in rows area and "Count" in values area.