Hello,
I have the certain pivot table in the attached workbook.
What I want to do is to use a formula that will choose certain dates in column A and sum the corresponding number in the adjacent column B.
For exemple I want to look for all the dates listed during June of 2019 then it will show the sum of numbers for all those adjacent cells with those specified dates
Currently the formula I use in the spreadsheet only counts the dates once and not repeating dates.
=SUM(IF(ISTEXT($A$3:$A$10000),0,IF(ISBLANK($A$3:$A$10000),0,IF(YEAR($A$3:$A$10000)=2019,IF(MONTH($A$3:$A$10000)=6,1)))))
So if for exemple if june 6, 2019 is listed in the pivot twice it will only show 1 not 2.
Any one?
Thanks
Bookmarks