Hallo Ray,

Sumproduct() does normally recognize both logical values as 0 while basic
calculations accept true/false as 1/0.
Assuming your product in column G, value in H, first month in I, Status in W
and your total product references in column A starting with the first
reference in A2 I suggest:

=SUM(($G$2:$G$8=$A2)*$H$2:$H$8*I$2:I$8*(($W$2:$W$8 ="Pending")+($W$2:$W$8="Won")))

Of course you need to enter this as matrix formula and modify the ranges as
required.

--
Regards

Joachim


"Ray from NZ" wrote:

Hi,
Thanks for looking at my XL problem. I have a spreadsheet below which I
want to use to give a basic sales forecast.

In Col G I have products. I also have a Status of "On hold, Won, Lost and
Pending" in column W.

What I want to do for each product is total them (count as a sale) in each
month provided that the status is either Won or Pending. I don't want to
count if they are lost or on-hold.

Here is what doesn't work !!! :-)

=SUMPRODUCT(J5:J27,S5:S27,"=if(G5:G27=G50,1,0)","= if(w5:w27="Pending"OR"Won",1,0)")

Example.

Product Value Sep Oct Nov Dec Status
A 55,000.00 1 On Hold
B 45,000 1 Pending
A 55,000 1 Pending
B 55,000 1 On Hold
A 55,000 1 1 Won
C 10,000 1 Pending
C 100,000 1 Pending

Totals
A 55000 55000
B 100000
C 10000 110000 100000
D

Any help would be greatly appreciated.

- Ray