R
Ronbo
I am trying to sum data in column M if the criteria in column F is met. The
criteria in F consists of 2 to 8 didget numbers such as 20, 2010, 20201, etc.
I want to sum any value in M when the criteria F is anything starting with
"20". Something to the effect of;
SUMIF(F:F,20*,M:M)
and I can not reduce the criteria in F down to 2 digets.
Thanks for any help.
Ronbo
criteria in F consists of 2 to 8 didget numbers such as 20, 2010, 20201, etc.
I want to sum any value in M when the criteria F is anything starting with
"20". Something to the effect of;
SUMIF(F:F,20*,M:M)
and I can not reduce the criteria in F down to 2 digets.
Thanks for any help.
Ronbo