Hello:
Please refer to attached file.
I need formula in cell B3 down to give result as 4,6,7,6......
I have highlighted the total entries for each date in column H,L,P, T
Let me know if you have any questions.
Thanks.
Riz
Hello:
Please refer to attached file.
I need formula in cell B3 down to give result as 4,6,7,6......
I have highlighted the total entries for each date in column H,L,P, T
Let me know if you have any questions.
Thanks.
Riz
Put on B3 and copied down
=SUMPRODUCT((($G$3:$G$33=$A3)+($K$3:$K$33=$A3)+($O$3:$O$33=$A3)+($S$3:$S$33=$A3)>0)+0)
Hello azumi:
Thanks a lot for help, however this will be for lots of date (31 days)and the above formula will be huge.
Would there be easy way.
Please let me know if you have any questions.
Thanks.
Riz
Hi Riz,
Enter this array formula in B3 and copy down
**Must be entered with Ctrl+Shift+Enter key combination.
Formula:Please Login or Register to view this content.
what was I thinking... it could be much easier with this
Formula:Please Login or Register to view this content.
Last edited by AlKey; 07-25-2017 at 08:44 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi Alkey:
Thanks a lot, makes my life easyyyyyyyyy
Riz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks