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.



"Don Guillett" wrote:


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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Erik (AP Inc.)" wrote in message
...
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

"Erik (AP Inc.)" wrote:

I have all my amounts in one table but want the output to sort between
two units (P01 & P02). 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