Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
HI All,
Thanks in advance,
we have the following data
want some result from the above sheet to below sheet
i want how many times the said condition matched and result will show in sheet3!c4 - condition one, if sheet3!a4 match Sales!B2:B and condition two is sheet3!c3 match Sales!C2:C
i have tried a formula in sheet3!c4 but its not working
help pls
Thanks in advance,
we have the following data
Time | name | Option |
5-3-2020 16:28:28 | name1 | Soap |
5-3-2020 16:30:07 | name1 | Soap |
5-3-2020 16:39:12 | name1 | Soap |
5-4-2020 5:31:19 | name4 | Juice |
5-5-2020 5:44:38 | name2 | Soap |
5-5-2020 5:44:57 | name2 | Juice |
5-5-2020 5:45:35 | name2 | suggesion |
5-5-2020 5:46:39 | name2 | Mango |
5-5-2020 5:47:34 | name2 | idea |
want some result from the above sheet to below sheet
Cell Formulas | ||
---|---|---|
Range | Formula | |
C3 | C3 | =COUNTIFS(Sales!B$2:B43,A3,Sales!C$2:C1109,C2) |
C4:C6 | C4 | =COUNTIFS(Sales!B3:B1110,A4,Sales!C3:C1110,C3) |
i want how many times the said condition matched and result will show in sheet3!c4 - condition one, if sheet3!a4 match Sales!B2:B and condition two is sheet3!c3 match Sales!C2:C
i have tried a formula in sheet3!c4 but its not working
help pls