Simple VBA formula

Microsoft Excel 2000/visual basic for ap...
July 14, 2009 at 11:24:38
Specs: Windows XP
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") = " "



See More: Simple VBA formula

Report •

July 14, 2009 at 11:38:54
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 point when discussing SUMIF statements.

Report •
Related Solutions

Ask Question