B
Bob Phillips
It is probably caused because you are comparing strings, and I didn't allow
for this. If both the A and B columns are text, use
TextBox11 = Evaluate("SUM(IF(((A1:A10)=""" & ComboBox1.Value & _
""")*((B1:B10)=""" & Textbox4.Text & """),D1
10))")
If only column A is text, and B is a number, use
TextBox11 = Evaluate("SUM(IF(((A1:A10)=""" & ComboBox1.Value & _
""")*((B1:B10)=" & CDbl(Textbox4.Text) & "),D1
10))")
Hope that this sorts it.
--
HTH
RP
(remove nothere from the email address if mailing direct)
for this. If both the A and B columns are text, use
TextBox11 = Evaluate("SUM(IF(((A1:A10)=""" & ComboBox1.Value & _
""")*((B1:B10)=""" & Textbox4.Text & """),D1
![Big Grin :D :D](/styles/default/custom/smilies/grin.gif)
If only column A is text, and B is a number, use
TextBox11 = Evaluate("SUM(IF(((A1:A10)=""" & ComboBox1.Value & _
""")*((B1:B10)=" & CDbl(Textbox4.Text) & "),D1
![Big Grin :D :D](/styles/default/custom/smilies/grin.gif)
Hope that this sorts it.
--
HTH
RP
(remove nothere from the email address if mailing direct)