AI Excel Formula Generator

Sum values in column A where column B = 'Yes'

=SUMIF(B:B,"Yes",A:A)

Count unique values in a range

=SUMPRODUCT(1/COUNTIF(A2:A100,A2:A100))

Get the last non-empty cell in column A

=LOOKUP(2,1/(A:A<>""),A:A)

Extract text between two characters

=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)

Calculate age from date of birth

=DATEDIF(A1,TODAY(),"Y")