Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Simple VBA formula

Comment:

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

Name: DerbyDad03
Date: July 14, 2009 at 11:38:54 Pacific

Reply:

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.

0

Excel button copy a value

printing diamond

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I have a question about write a simple sum formula in Excel of MS Office 2000. I want adding every nine line number togather, example: sum = c5 + c14 + c23 + c32 + c41 + c50 ... until to + c275. Is th...

Summary: Hey, I am working on a quick spreadsheet for reporting for work, and everything works fine, except for 1 sheet, which i'm not sure how to do it! I'm not very advanced at excel, but i have been using V...

Summary: Hi, Background Information: I am creating a DASHBOARD sheet to be at the beginning of my workbook with multiple sheets. In DASHBOARD I have created a chart that contains client analysis formulas tha...