O
ORLFREIGHTBOY
Hello all-
I have two sheets, sheet1 and sheet2. I am condensing sheet1 (filled with
approx 5000 rows to sort through)
Sheet1:
branch acct# name total
1 12345 misc $100.00
2 12345 misc $50.00
1 12367 oil $100.00
Sheet2:
branch acct# name total
1 12345 misc ???
If I was doing an if/then setup on this, it would be IF branch=1 AND
acct#=12345 AND name=misc on Sheet1 THEN put the total from sheet1 into the
total cell for sheet2. What would be the best way to tackle this? What
formula would I be placing in sheet2 total cell? Thanks In Advance - Jason
I have two sheets, sheet1 and sheet2. I am condensing sheet1 (filled with
approx 5000 rows to sort through)
Sheet1:
branch acct# name total
1 12345 misc $100.00
2 12345 misc $50.00
1 12367 oil $100.00
Sheet2:
branch acct# name total
1 12345 misc ???
If I was doing an if/then setup on this, it would be IF branch=1 AND
acct#=12345 AND name=misc on Sheet1 THEN put the total from sheet1 into the
total cell for sheet2. What would be the best way to tackle this? What
formula would I be placing in sheet2 total cell? Thanks In Advance - Jason