vba for collating data or instead of using SUMIFS

[Angelique Cassam]

Hello all,

I have a worksheet I would like to collate the quantities (column E) of wine for into a new totals column. This works fine but is only looking at one condition - the name of the wine (column A) and not the year (column B) as the 2nd condition. I have a vba script to look which will collate for the condition of column A but I cannot get it to work with the 2nd condition of column B. It keeps lumping it into one total.

I am pretty sure is it the line:

Set Rng = Range(Range("A1"), Range ("A" & Rows.Count).End(xlUp)

Could somebody have a look and help me please.

Thank you

[bakerman2]

Does this work for you.

Please Login or Register  to view this content.

[Angelique Cassam]

Thank you so much bakerman2.

[bakerman2]

Glad to help and thanks for rep+.