Totals by month

Brett Allard

Hello,

I'm trying to figure out how to get totals by specific month. There are 3 columns I'm trying to pull data from, a monetary column called "Unit Price," a dropdown list column called "Produced," with options that read "1. In Production" and "2. Produced," and a date column. Basically, I want to have a cell that shows running totals for a month once I click the "Produced" column to "2. Produced." 

Adam Overton

I think you need another column to represent the "produced in month" value, and then count that.

So the other column would be =IF([Production]2 = "2. Produced", MONTH([Date]2), "")

Which will put the month of produced stuff in that column. I called it "Month if Produced".

Then you can make a formula like =COUNTIF([Month if Produced]1:[Month if Produced]10, 5), and that will give you the count of things for May.

 

Brett Allard

I'll try it out. Thank you.