Punweet Singh
New Member
- Joined
- Sep 22, 2020
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hi Everyone!
Your advice and support here would really go a long long way. I will try and explain my issue below as best as possible
Refer to Sample Sheet - Google Sheets - create and edit spreadsheets online, for free.
The data is Range A14:I36 will be copied daily into a this sheet. I have added some basic macros in order to retrieve the data in J14:AL36. Where i need your help is populating the data in D5:J10
For example - In cell D5 i need to be able to count all the cells from column K14:K36 that is equal to "6" or ">0" BUT it should also fit the criteria that the remaining values in row L14:AL14 is blank or "0" A similar situation follows for all the remaining cells in D5:J10
it is possible that a customer has ordered a Indian water 6 pack and also a grapefruit tonic water 12 pack in which case that will count in cell C9 (Other).
I hope this wasn't too confusing and ill be happy to try and answer any queries. thank you !
Your advice and support here would really go a long long way. I will try and explain my issue below as best as possible
Refer to Sample Sheet - Google Sheets - create and edit spreadsheets online, for free.
The data is Range A14:I36 will be copied daily into a this sheet. I have added some basic macros in order to retrieve the data in J14:AL36. Where i need your help is populating the data in D5:J10
For example - In cell D5 i need to be able to count all the cells from column K14:K36 that is equal to "6" or ">0" BUT it should also fit the criteria that the remaining values in row L14:AL14 is blank or "0" A similar situation follows for all the remaining cells in D5:J10
it is possible that a customer has ordered a Indian water 6 pack and also a grapefruit tonic water 12 pack in which case that will count in cell C9 (Other).
I hope this wasn't too confusing and ill be happy to try and answer any queries. thank you !