Easily add over 300+ fields to Values section & Sum?

[ghladik]

I have a PT that works off another formula based on a criteria that if a specific day of the year falls within the rows date range, place a "1" in the cell. Otherwise place a "0".

B1: 8/1/14 C1: 8/2/14 D1: 8/3/14...
A2 7/31/14-8/2/14 1 1 0
A3 8/3/14-8/5/14 0 0 1
A4 7/24/14-8/5/14 1 1 1

The PT picks up the 1's and 0's by date and sums them up:
8/1/14: 2
8/2/14: 2
8/3/14: 3


When setting up the PT, I have to manually add each date (365 of them) to the Values on the PT and then switch from "count" to "Sum". Is there a way to do this in bulk, quickly?

Please tell me there is!!

[tuph]

Please attach a sample of your workbook so we don't need to re-create your work to find possible solutions. Remember to remove/replace sensitive info before uploading the file.

[romperstomper]

You would need to use code or rearrange the data source which is not in ideal layout for a pivot table by the sounds of it.