Vlookup

[Kevin Carter]

Hi

i have a table containing differnet types of holidays
Vac
Spring
bank hol
in column A i have the week number from a7:a740
in column B i have the date
in column C i have the day
in D6 to M6 i have the employee names
in D7 to m740 i enter the type of holiday the employee has taken.
What i want to search column A for the week number then count the number of occurrence of a holiday type for each day

i have tried

=COUNTIF(D9:M9,"Vc") works fine but i need to count only occurences for a given week number

is vlookup the best solution for this?
and if so can i use count if with Vlookup

thanks

kevin

 

[Don Guillett]

Hi

i have a  table containing differnet types of holidays
Vac
Spring
bank hol
in column  A i have the week number from a7:a740
in column B i have the date
in column C i have the day
in D6 to M6 i have the employee names
in D7 to m740 i enter the type of holiday the employee has taken.
What i want to search column A for the week number then count the number of occurrence of a holiday type for each day

i have tried

=COUNTIF(D9:M9,"Vc")  works fine but i need to count only occurences for a given week number

is vlookup the best solution for this?
and if so can i use count if with Vlookup

thanks

kevin

Send your file with a complete explanation and before/after examples
to dguillett1 @gmail.com