use sumproduct function... please check my recent email solution
.
On Thu, Jan 24, 2013 at 1:55 AM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Dear Friends,
** **
I need your help
** **
Refer attached file,
**1) **“Detail” sheet contains handover details of
Dear Friends,
I need your help
Refer attached file,
1) Detail sheet contains handover details of cabs in Nov/Dec. Column AI
shows working for Gross TAT AJ shows working for Net working hours.
2) Holiday list, needs to be updated as applicable for NAL. This need
not cover Sunday.