VLOOKUP & COUNTIF

0
votes

I'm looking for some help on trying to combine functions.

I think I need VLOOKUP & COUNTIF.

I have Sheet 1 with a list of clients, column A, I then have 12 other tabs Jan-Dec same table format on each, client listed in column C.

On sheet 1, I want to count from every month tab how many times listed (invoices sent) Not every client in the list will appear on the month invoice tabs , others more than once.

Please see screenshot attached

Any advice would be appreciated.

Thank you Amy

1
excelvlookupcountif

1 Answers

1
votes

You only need CountIf. Just reference the client on Sheet 1:-

=countif(January!C3:C100, Sheet1!A3). Copy this down to reference the client on each row.

You could also consider the following for a better working and easier spreadsheet:-

-Define ranges and reference those instead
-Copy all your monthly data with the year into one sheet. Have a column for month and year then just autofilter to get the month you want - using countif to also reference the month and year if you just want a particular one in question

You'll find it easier to grown your spreadsheet and build formulae if your data is tidy and less dispersed.

Hope this helps,

Phil