Sum by dept and date

[Erik (AP Inc.)]

I have all my amounts in one talbe but want the output to sort between the
two. I am also having the values counted and totaled by month.

=SUMPRODUCT(--ISNUMBER('C.I Log Paulding 07'!E2:E500),--(MONTH('C.I Log
Paulding 07'!E2:E500)=1))

and

=SUMPRODUCT(--(MONTH('C.I Log Paulding 07'!$E$2:$E$496)=1),--('C.I Log
Paulding 07'!$E$2:$E$496<>"")*('C.I Log Paulding 07'!$O$2:$O$496))

I want the result of this formula but only if the value in Cell F2:E500 =
"P02"

Maybe its simpler than I think, but I haven't had any luck this morning.

Thanks
Erik

 

[Erik (AP Inc.)]

Here is an example of my sheet

(E) (F) (O)
Date Unit Savings
1 P01 100.00
2 P02 350.00
3 P01 200.00

 

[Don Guillett]

Try just adding the other parameter to the first formula in the SAME manner

 

[Erik (AP Inc.)]

Im not sure how the original formula works so its hard to copy.

The goal is to get the total savings per unit by month.