Sumif.. change range based on a cell value?

[gsrmini]

Any idea or suggestion on where to start.
i have a couple of fairly complex =sumif formulas adding amounts based on each individual employee.
I'd like to find a way to modify the sumif range according to a value in a cell.

My data chart has a column for job#s these consecutely increase, anyway my sumif range could begin to calculate if greater than #### in my job numbers column?

Thanks,

 

[Aladin Akyurek]

Any idea or suggestion on where to start.
i have a couple of fairly complex =sumif formulas adding amounts based on each individual employee.
I'd like to find a way to modify the sumif range according to a value in a cell.

My data chart has a column for job#s these consecutely increase, anyway my sumif range could begin to calculate if greater than #### in my job numbers column?

Thanks,

Care to post a small sample along with the desired results?

 

[gsrmini]

Heres one of my Sumif statements:
=SUMIF(Sheet1!B6:$L$1000,Sheet2!D12,Sheet1!J6:$J$1000)
(to simplify, sheet1-entire data chart, sheet2-employee name to referance, sheet1 J: amounts to sum)

the chart is sales by salesperson, w/ expenses, overhead, project names, project #'s etc. Listed in order of project number (top to bottom)

My sumif totals (sales) for example, could be any column, based on salesperson name.

Any suggestion of either modifying my =sumif or a fresh formula which might allow me to add total values based on specified salesperson & have it only calculate if value in sheet1!C6 (project numbers) is greater than (specified)

Basically a sales/expenses summary per salesperson filtered by (date), I have no dates in my chart, project numbers are consecutive so would work as a method of filtering how far back as a timeline to be summarizing amounts.

Make any sense?

possibly a vlookup if > than statement, not sure though how I format the sumif part given a varied range required.

Any suggestions would be great.
Thanks,

 

[Joesif]

Should
=SUMIF(Sheet1!B6:$L$1000,Sheet2!D12,Sheet1!J6:$J$1000)
be
=SUMIF(Sheet1!B6:$B$1000,Sheet2!D12,Sheet1!J6:$J$1000)
?

 

[gsrmini]

Should
=SUMIF(Sheet1!B6:$L$1000,Sheet2!D12,Sheet1!J6:$J$1000)
be
=SUMIF(Sheet1!B6:$B$1000,Sheet2!D12,Sheet1!J6:$J$1000)
?

It does not seem to make any difference in the results. I understood the 'range' to be that of the entire chart. while 'sum_range' to be specific column to sum.
I easily could be mistaken, however both seem to produce the same result.

Thanks.