CountIFS

[markusvirus]

Hi Experts,

Need some help with placing formulas under my "SUMMARY" sheet, I am manually entering the formulas per date as of now. is there any other way to expedite the way I'm doing it now? I am looking to expand the dates as well.

Thanks!

[shukla.ankur281190]

Yes you can but you have to do some workout for the same.

First you have to put date criteria in other cells as they are merged and will not work if cell are merged. Follow the below step to create criteria in easy way.

Un-merge the cell of date criteria then put =E5 in E3 cell then copy the same thing in alternate cell in row 3. Now select the range E3:R3 then press control G ->>> you will get a window Go to special window ->>>click on tab special ->>> and click on blank cell. All the blank cells will be selected now just put = this sign and select before cell ( mean mentioned date cell ) then with pressing control and then enter. This step will populate the same date which are mention before cell.

Now try below formula

E8

Please Login or Register  to view this content.

Drag towards the cell.

Check the attached file.

you can hide row no 3 also after completing your all the steps.

Hope it will help you.