How do we count named X,Y and Z satisfying the criterias C1,C2,C3,C4 in the yellow zone in the years 2021 and 2022?
screen shot.jpg
Shortly, I want to create a table like the green zone. Please find the attachment..
How do we count named X,Y and Z satisfying the criterias C1,C2,C3,C4 in the yellow zone in the years 2021 and 2022?
screen shot.jpg
Shortly, I want to create a table like the green zone. Please find the attachment..
Last edited by student_md; 07-30-2022 at 08:47 AM.
There are instructions at the top of the page explaining how to attach your sample workbook.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you for your interest.
I have uploaded example Excell workbook.
Last edited by student_md; 07-30-2022 at 08:17 AM.
2021:
=COUNTIFS($C:$C,$H$1,$A:$A,$G3,$B:$B,H$2)
2022:
=COUNTIFS($C:$C,$H$1,$A:$A,$G3,$B:$B,H$2)
If you removed the merged cells, we could have one formula for everything.
Many thanks.
We can removed the merged files. So, what is the one formula?
This:
=COUNTIFS($C:$C,H$1,$A:$A,$G3,$B:$B,H$2)
AliGW on MS365 Beta Channel (Windows 11) 64 bit
G H I J K L M N O 1 Name 2021 2021 2021 2021 2022 2022 2022 2022 2 C1 C2 C3 C4 C1 C2 C3 C4 3 X 2 1 4 5 1 3 1 3 4 Y 1 1 0 3 1 0 0 0 5 Z 0 1 0 0 2 0 1 0
Sheet: Sheet1
thank you very much.
Glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks