Jan 11 2022 05:10 PM
Does anyone can help me to solve this prob?
Jan 11 2022 08:48 PM
Jan 11 2022 08:52 PM
Jan 11 2022 09:04 PM - edited Jan 11 2022 09:09 PM
Do you have valid Data in AA to BB?
Try this in place of the formula you are currently using (shown in the picture in cell N2):
SUMIF(M2:M521,"<>ISERROR("&M2:M521&")",M2:M521)
Jan 11 2022 09:13 PM - edited Jan 11 2022 10:17 PM
@geminiwwwww20 Note that your formula has three apostrophes ( ''' ),
rather than the two quote marks ( "" ) as indicated in the help screen.
That should fix it.