Hi
I have data in columns like this below. A- sellers, B - shops, C- shop addresses
<tbody>
</tbody>.....
in cell H2 I need to count for example total number of shops ana has, or total number of addresses of AA shop...
I have data validation lists in cells E2, F2, G2 and I use them as criterias in formula. my formula should include something like a wildcard * which we use in sumifs because I might not indicate seller name and want to count total number of addresses of a specific shop, or I only choose seller name and I want number of addresses of every shop he/she has.
has anyone any idea how to do this? :/
thanks in advance
I have data in columns like this below. A- sellers, B - shops, C- shop addresses
<tbody> </tbody> |
<tbody>
</tbody>
in cell H2 I need to count for example total number of shops ana has, or total number of addresses of AA shop...
I have data validation lists in cells E2, F2, G2 and I use them as criterias in formula. my formula should include something like a wildcard * which we use in sumifs because I might not indicate seller name and want to count total number of addresses of a specific shop, or I only choose seller name and I want number of addresses of every shop he/she has.
has anyone any idea how to do this? :/
thanks in advance