Hi guys i need help,
how to use formula Countif with between two date to get pivot table data.
example: Kent buy product at 01-01-17 with two time, first time is 1000, second time is 200, so pivot table show me total is 1200.so no matter how many time kent buy at same day, also count for 1 time. if i choose date 01-01-17 to 02-01-17, kent at 01-01-17 two time to come buy product , 02-01-17 1 time to come buy product, so Total kent is come to my shop for 2 time only.
(and if pivot table got 0, how to use counif to this)
Thanks
how to use formula Countif with between two date to get pivot table data.
example: Kent buy product at 01-01-17 with two time, first time is 1000, second time is 200, so pivot table show me total is 1200.so no matter how many time kent buy at same day, also count for 1 time. if i choose date 01-01-17 to 02-01-17, kent at 01-01-17 two time to come buy product , 02-01-17 1 time to come buy product, so Total kent is come to my shop for 2 time only.
(and if pivot table got 0, how to use counif to this)
Thanks
