Morning - I'm having difficulties with a spreadsheet here that includes VLOOKUPS and Count functions.

I have Sheet 1 with the Account Name and ID and Sheet 2 has Account Name, ID and Sales (broken out by month).

So, sheet 2 is summed to show what total sales were in FY 14. I am looking for all customers > $1,000 from the data set and represent it in Sheet 1.

Currently I have a Vlookup to Account ID from the total data set of FY14 and then a Countif of the FY14 column in Sheet 2 with a ">1,000" qualifier.

What am I doing wrong?

Thanks,