How to calculate number of text occurrences in column and return a number

Dan HarrisDan Harris ✭✭✭✭
edited 11/27/20 in Formulas and Functions
11/27/20 Edited 11/27/20
Answered - Pending Review

I am trying to calculate when a Y appears in a specific column and return the number 2 when this occurs and 0 when is N, any ideas on best formula have been pulling hair out!!




  • Kelly MooreKelly Moore ✭✭✭✭✭

    Hi Dan

    I assumed this wasn't a cross-referenced sheet

    =IF(UPPER([Your column name]@row) = "Y", 2, 0)

    The UPPPER function will force all entries to be viewed as capitalized letters. The false function will default to a blank cell if we left the last comma and zero out of the equation. As written, any false will return a zero.

Sign In or Register to comment.