SUMIF with "=" condition giving #NAME! error
SUMIF with "=" condition giving #NAME! error
I have =SUMIF(
H21:H27
;=&
B55
;
I21:I27
) which is throwing an error. Have tried =SUMIF(
H21:H27
;=
B55
;
I21:I27
), =SUMIF(
H21:H27
;"="&"
B55"
;
I21:I27
) and =SUMIF(
H21:H27
;"=
B55"
;
I21:I27
)