Quick help with Vlookup

[colleendeborah]

In column A, I have the same text. It may span from A7 one day to A34. The next day, I will update this list from A7 to A24, for example. In column D, I have the cost.

I need to sum the cost daily and place it in a different tab of excel (which I know how to do).

The data that I enter (gathered from a different cvs file) daily spits out a "total" line so I don't want to just sum column D from A7 - A100 ( to cover myself if rows increase or decrease) since there is a always total line automated from the cvs file I get.

I am doing this action for several different tabs every day, so I don't want to always delete the total line and update the spreadsheet in order to work.

How do I automate this? Someone suggested vlookup, but I don't know how to do that.

Here is a visual of what I mean (attached)

[TMS]

One way:

Please Login or Register  to view this content.

or just:

Please Login or Register  to view this content.

Regards, TMS

[matklt]

Hi

You could try this code =SUMIFS(D:D,A:A,"Product A")

This will sum only the rows where there is a product thus not counting the Total row. This wont work if you have different products in the same tab however.

You could try this in that case =SUMIFS(D:D,A:A,"<>Total") this will sum every line in column D were there isn't the word total in column A

Regards

Matt

[TMS]

Or, given that it is a Total row and you want the total, maybe just:

Please Login or Register  to view this content.

Regards, TMS