|Subject:||SUMIF with alphanumeric criteria range question|
|Posted by:||Steve (sy2…@georgetown.edu)|
|Date:||Sat, 15 Sep 2012|
Dear group members,
I am trying to sum up entries from different categories represented by alph=
anumeric string. I need sums from multiple categories that are noncontinuou=
s, such as a sum for Education (H5000-H5200,X3500). How can I set the crite=
ria as sth like >H5000 AND <H5200 OR =3DX3500? Or how can I extract the num=
bers (I know how to separate letters from strings) and do SUMIFS with multi=
ple criteria? Or how can I build a function for this purpose?
In the sample below, the left column contains the categories and right colu=
mn their values.
Thanks in advance!