Hello:
I am trying to use the sum if formula where in my "Range" data field, I am looking at differenet text strings all starting with the same text, for example, BA: Abcd, BA: Efgh, BA: Ijkl, etc etc.
I want to use sum if to sum all the ones that begin with "BA:" but cannot quite get there.
Your help will be appreciated.
Thanks
I am trying to use the sum if formula where in my "Range" data field, I am looking at differenet text strings all starting with the same text, for example, BA: Abcd, BA: Efgh, BA: Ijkl, etc etc.
I want to use sum if to sum all the ones that begin with "BA:" but cannot quite get there.
Your help will be appreciated.
Thanks