MadHatsJess
New Member
- Joined
- Jul 12, 2017
- Messages
- 27
Hi
I have two sheets.
Sheet one has a Store name, Product Name, Item version and Price. Sheet two has the raw data.
I am using COUNTIFS to find the volume of sales using certain criteria within a cell.
I am using the formula below and it is returing a 0 but it should return 1 in this case
=COUNTIFS('Sheet 2'!A:O,B17,'Sheet 2'!A:O,C17)
Can anyone help please?
Thanks
Jess
I have two sheets.
Sheet one has a Store name, Product Name, Item version and Price. Sheet two has the raw data.
I am using COUNTIFS to find the volume of sales using certain criteria within a cell.
I am using the formula below and it is returing a 0 but it should return 1 in this case
=COUNTIFS('Sheet 2'!A:O,B17,'Sheet 2'!A:O,C17)
Can anyone help please?
Thanks
Jess