Hi
I need a formula that will count how many styles I am carrying per brand. The table array where I hold my data is shown below, cells A-D.
Cell B states the name on the style, cell A is the size breakdown for that particular style.
Cell C shows the brand attached to that style
Cell D is stock holding for the individual sizes of that style.
What I am looking to do is count how many styles I have in stock based on the brand (which will alternate as I am using a list function from validation which I can then scroll through to display data for the brand of my choosing) and also the style has to have a qty of > 0. That's a qty of >0 for the whole style, not just the individual sizes.
For example, from below, if K33076Dress32849Rasb/Cream was qty 0 for each size then I wouldnt want it to count the style, but if just one size has a qty, I would like it would count it.
Hope someone can help
Thanks
<tbody>
</tbody>
I need a formula that will count how many styles I am carrying per brand. The table array where I hold my data is shown below, cells A-D.
Cell B states the name on the style, cell A is the size breakdown for that particular style.
Cell C shows the brand attached to that style
Cell D is stock holding for the individual sizes of that style.
What I am looking to do is count how many styles I have in stock based on the brand (which will alternate as I am using a list function from validation which I can then scroll through to display data for the brand of my choosing) and also the style has to have a qty of > 0. That's a qty of >0 for the whole style, not just the individual sizes.
For example, from below, if K33076Dress32849Rasb/Cream was qty 0 for each size then I wouldnt want it to count the style, but if just one size has a qty, I would like it would count it.
Hope someone can help
Thanks
KA3076 Dress 32849 Rasberry/Cream S | KA3076Dress32849Rasb/Cream | Glamorous Old | 2 |
KA3076 Dress 32849 Rasberry/Cream M | KA3076Dress32849Rasb/Cream | Glamorous Old | -1 |
KA3076 Dress 32849 Rasberry/Cream L | KA3076Dress32849Rasb/Cream | Glamorous Old | 0 |
CK0550 Dress 32029 Rust XS | CK0550Dress32029Rust | Glamorous Old | 0 |
CK0550 Dress 32029 Rust S | CK0550Dress32029Rust | Glamorous Old | 0 |
CK0550 Dress 32029 Rust M | CK0550Dress32029Rust | Glamorous Old | 0 |
CK0550 Dress 32029 Rust L | CK0550Dress32029Rust | Glamorous Old | 0 |
1393 Ladies dress-32322 Black/mustard XS | AN1393dress-32322Blk/mustard | Glamorous Old | 0 |
N1393 Ladies dress-32322 Black/mustard S | AN1393dress-32322Blk/mustard | Glamorous Old | 1 |
N1393 Ladies dress-32322 Black/mustard M | AN1393dress-32322Blk/mustard | Glamorous Old | 0 |
N1393 Ladies dress-32322 Black/mustard L | AN1393dress-32322Blk/mustard | Glamorous Old | 1 |
Fur Collar Coat Green S | FurCollarCoatGreen | Fast Fashion Womens Old | 0 |
Fur Collar Coat Green M | FurCollarCoatGreen | Fast Fashion Womens Old | -1 |
Fur Collar Coat Green L | FurCollarCoatGreen | Fast Fashion Womens Old | 1 |
Fur Collar Coat Green XL | FurCollarCoatGreen | Fast Fashion Womens Old | 0 |
Fur Collar Coat Green XS | FurCollarCoatGreen | Fast Fashion Womens Old | 0 |
NL2785 Ladies Parka Khaki 8 | NL2785ParkaKhaki | Fast Fashion Womens Old | 0 |
NL2785 Ladies Parka Khaki 10 | NL2785ParkaKhaki | Fast Fashion Womens Old | 0 |
NL2785 Ladies Parka Khaki 12 | NL2785ParkaKhaki | Fast Fashion Womens Old | 0 |
NL2785 Ladies Parka Khaki 14 | NL2785ParkaKhaki | Fast Fashion Womens Old | 2 |
<tbody>
</tbody>