How to sum counts from a certain pivot table

[Horrid Wilting]

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

[davsth]

if you wish to sum a whole month and the dates are truly dates

=SUMIFS(B:B,A:A,">="&G19,A:A,"<="&EOMONTH(G19,0))

where g19 is the 1st of the month you are interested in as a date

[Horrid Wilting]

Hello,

Thanks davsth i don't know how this formula worked but it really did the trick!!!

Have a nice day ahead