Microsoft Excel 2000/visual basic for ap...

Hi I need a type fo sumif formula this works but it only uses d1 as the main reference point where I need it to pick up when there is what ever is in a1 and b1 If Worksheets("Sheet1").Range("d1,d10") = Sheet1.Range("a1") & " " & Sheet1.Range("b1") Then

Sheet1.Range("g1").Formula = "=sum(e1:e10)"

Else: Sheet1.Range("g1") = " "thanks

Sacha

You need to explain yourself better, perhaps with some examples of input and output data. You say

"it only uses d1 as the main reference point",yet you use

"Range("d1,d10")" in your example.I'm not familiar with the term

main reference pointwhen discussing SUMIF statements.

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History