help me put sum if formula in excel file. The formula should change the value range to be picked depending upon variable given in d1 to g1 in sheet 1.
help me put sum if formula in excel file. The formula should change the value range to be picked depending upon variable given in d1 to g1 in sheet 1.
Hi and welcome to the forum :0
Will you always want to add all columns on sheet2? Or will there be times when you only want 2 or 3 of the columns?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Will the columns being entered in D1:G1 always comprise a contiguous range?
For example, will you ever do something like this:
D1 = NS03
E1 = NS36
F1 = empty cell
G1 = empty cell
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
lol is there an cho in here Tony?
I have a slow internet connection.
I would be required to add all columns in sheet 2
If you only want the total, you dont need to sum the values - again. Just reference them...
=INDEX(Sheet2!$F:$F,MATCH(Sheet1!B7,Sheet2!$A:$A,0),1)
copied down
I would be required to calculate for each of in variable in sheet 2 and a not just rirsk
It looks like you already have a category total on sheet2. Can't you just do a lookup for the total as FDibbins suggested?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks