Prev: Print To pdf Not Working
Next: Change to different active printers on different PC's
From: Eric on 22 Apr 2010 09:30
I am looking to have a returned cost based on 3 criterias

1. job location (cell F1)
2. Mix type (cell F2)
3. Plant (cell F3)

I have it set up in a table format....

Job Loc. Mix type Plant Cost
A1 B1 C1 D1
1 L 12.5 3 $12.00
2 L 9.5 2 $5.00
3 M 12.5 1 $8.00

F1= L F2=12.5 F3= 3
returns D1

I hope this makes sense......

Eric
From: Brian on 22 Apr 2010 09:47
I think I am following but not positive. If you have 2007 why not just use a
SUMIFS?

"Eric" wrote:

> I am looking to have a returned cost based on 3 criterias
>
> 1. job location (cell F1)
> 2. Mix type (cell F2)
> 3. Plant (cell F3)
>
> I have it set up in a table format....
>
> Job Loc. Mix type Plant Cost
> A1 B1 C1 D1
> 1 L 12.5 3 $12.00
> 2 L 9.5 2 $5.00
> 3 M 12.5 1 $8.00
>
> F1= L F2=12.5 F3= 3
> returns D1
>
> I hope this makes sense......
>
> Eric
 | 
Pages: 1
Prev: Print To pdf Not Working
Next: Change to different active printers on different PC's