Trouble getting formula to work

[bbenaway]

Am wanting to sum a row by looking at certain criteria list in columns A and B. For this example, am looking in row 105,column A for the entry of "12a" and row 105, column B for the entry "Toner". Both criteria MUST exist, and if so, then sum the numbers in column C.

Last, I want to subtract the value in column D from that total.

In the attachent, I have a value of 34+50=84-10=74.

74 would be the final value.

I have used the following formula: =SUMPRODUCT(((B104:B112="12a")+(C104:C112="toner"))*D104112). I think the way the formula is set, it is looking at either or criteria instead of looking at both criteria together before summing up the values.

Thanks in advance for any and all help.

 

[Gavona]

change the plus to a *.
(True equates to 1, False equates to 0)

Gavin