Forum Discussion
Solved
Help with VLOOKUP and nested IF formula, if that is what is required to solve my problem?
I am trying to find the number of staff employed in a month by asking Excel to look up in a column for the words 'Basic Salary' and then look x columns across a table to see if there is a value great...
Dear R Leman
plz chk the attached file Green colored cells
I'm attaching a spreadsheet that I think works. It uses this formula to count up the number of basic salaries in a given month:
=COUNTIFS(tbl_data[[Column1]:[Column1]],"Basic Salary",tbl_data[Feb-17],">0")
countifs lets you count something that matches more than 1 criteria, in this case that in column 1 the row says Basic salary, and in the Feb-17 column there is a number in there that is greater than 0.
When you drag this formula right, 'month' column will move right as well
Thanks doesn't quite do the copy across. Have checked other reply to my original and it works - thanks very much for your help though
- Welcome