Create Report based on Date Range

[eventer289]

I am in need of creating a report based on logged values.

Here is the data layout that I need to report on.

https://lh5.googleusercontent.com/-H.../Untitled2.png

I need to create "report" formatted like the layout below that, based on the date range entered (begin date and due date), shows the count of the number of instances within that date range that the "Remaining" columns in the above photo was positive, 0, or negative.

https://lh4.googleusercontent.com/-8...5/Untitled.png

I cannot seem to figure out how to setup the formulas to display this information. Does anyone know how this can be done?

[Pepe Le Mokko]

Why post pictures when you need a sheet?

[eventer289]

Why post pictures when you need a sheet?

It was the simplest thing to do at the time.

[royUK]

Not the best way to get help though! Those pictures don't even help, we need to see how the data is laid out & what you expect from the report.

My suggestion

[eventer289]

The photos I attached are exactly as the sheet is laid out. The second photo with the yellow cells is to give you an example of the report criteria.