ATTN: Excel Pros: How to use a nested if function in excel to calculate vacation days?

=IF(B6="ft",15,IF(B6="pt",10,0))

The solution is to use countif and offset worksheet functions together with offset nested inside countif. Assume you have your 12 mth table on sheet2, excluding the column titles which is the month number the data block is A2:L21. The cell to show result, you put formula =COUNTIF( OFFSET( Sheet2!A2:A21, 0,A1 ,20,1),1) Inside the offset function: Sheet2!A2:A21 is the 1st mth data 0 is the offset of row, irrelevant in this case A1 is the offset of column, enter integer range from 0 to 11(1st mth to 12th mth) in Cell A1, or directly replace A1 with integer of that range. When enter 0(either in the formula or in cell A1), it means using A2:A21(1st mth) itself, if 11 is entered, it means move right 11 column from A2:A21 which is the 12th mth. 20 is the number of rows you want the formula return, 1 is the number of column you want the formula return. Hope this helps.