Hey,
I have a small problem
In column C we have the process list and status is in column D. By comparing the status I need the each process total list. please find the attachment for your reference. shall we use the countif function.
Kiran
Hey,
I have a small problem
In column C we have the process list and status is in column D. By comparing the status I need the each process total list. please find the attachment for your reference. shall we use the countif function.
Kiran
Hi,
in K5 to be copied across
=COUNTIFS($C$2:$C$20,$J5,$D$2:$D$20,K$4)
Hope it helps
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Please find attached file :D
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Thanks for the feedback. :D
If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks