Dear I have a consolidated history.xlsx Excel file. In thison consolidated histy sheet I need to sum the column J (Manday) values after deselecting (holiday & leave) on column K ( Nature of visit). The filter condition is it has to de-select only holiday & leave. And the sum value should be display in sheet2 B3 cell.
I am attaching my excel file here.
Pls give me the program for the above condition
Reply With Quote