VLOOKUP? or another formula?

[kimberlie3]

I have a spreadsheet that I am trying to automate to make things easier. This is a spreadsheet that will have additional rows added that I am looking to auto populate. This is what I am doing:

1. populating a column with pretax amount by using formula (matching-sales tax)

2. Then previously I was using formulas to get the total spent for each FCN/Line but would manually have to go in and use the sum formula for each FCN/Line

Is there a way I can make this simple? I attached a photo of an example and what I am looking to do. The green section is what it would look like if I did it manually, but after a few months, I usually have a few hundred rows or more and can be time consuming doing it manually.

Any help would be greatly appreciated!!

 

[kimberlie3]

Ok, that's expected.
Try to do the same formulas but for B and C 25-43.
Then check:

=B25=D8

and

=C25=E8

The B25=D8 is false and =C25=E8 is flase as well.......thinking this should be true?

 

[Cubist]

Try this in E25:

=SUM($G$3:$G$18*(TRIM($D$3:$D$18)=TRIM(B25))*(TRIM($E$3:$E$18)=TRIM(C25)))

 

[kimberlie3]

Try this in E25:

=SUM($G$3:$G$18*(TRIM($D$3:$D$18)=TRIM(B25))*(TRIM($E$3:$E$18)=TRIM(C25)))

Still gave a zero....but I think I found a work around....in B25:43 and C25:43 I copied and pasted the cells from D3:18 and E3:18 so the cells in B25:43 and C25:43 were in the exact same format

 

[Cubist]

Still gave a zero....but I think I found a work around....in B25:43 and C25:43 I copied and pasted the cells from D3:18 and E3:18 so the cells in B25:43 and C25:43 were in the exact same format

That might be a temporary solution, but it might happen again. If you wish to pursue further, we would need to see a copy of your worksheet. You can use DropBox for free of charge.