I am needing help with another formula,
in another sheet I want to extract data from the sheet above
I want to get an average of days (green Highlighted amounts)
is IF DEPT contains REF what is the average of Green Highlighted amounts) and the same for NIS and SSS
Help Article Resources
Check out the Formula Handbook template!