Excel "=IF" Formula including text and number values

[paulfurlong]

HI, any help would be GREATLY appreciated

In Column A1 to 10, I have a series of currency ammounts (for potential sales values);
In column B1 to 10, I have a "yes" or "no" text to show whether they are likely to go through or not;

I've tried to use the =IF formula to give me a total at the bottom of Column A of the "likely sales" with "YES" in column be next to them, and for this to be updated as I change from "YES" to "NO" but nothing seems to work!?

Does anyone have ideas?

Thansk in advance

 

[VoG]

Try SUMIF

Excel Workbook
	A	B
1	3.00	Yes
2	3.00	No
3	9.00	Yes
4	5.00	Yes
5	10.00	No
6	1.00	No
7	3.00	No
8	3.00	No
9	7.00	No
10	7.00	No
11
12	17.00
Sheet2

 

[dafan]

=SUMIF(B1:B10,"yes",A1:A10)

 

[SteveO59L]

try countif()

something like

=countif(b1:b10,"yes")

 

[Walky]

Hi there, try:

=SUMPRODUCT(--(B1:B10="YES"), --(A1:A10))

Regards,

W.

 

[paulfurlong]

thanks to all! It so simple and logical when you see it isn't it!? I was trying far too complicated 'solutions'.
Much appreciated