Hi,
This is for work, I have an header "aaa" or "bbbb", that the user may paste in the wrong position by mistake. In this example I need to count the number of 1's below the header aaa, or bbb. The difficulty here is that, "aaa" might be in column,a, b c etc... so I need something to find the header, and then to count the 1s (in this case below).
Thanks,
With your small sample this will work, but as you extend your data, adjust the parts in red
=COUNTIF(INDEX($G$5:$H$7,,MATCH($D6,$G$4:$H$4,0)),1)
Last edited by jeffreybrown; 11-27-2015 at 06:05 PM.
HTH
Regards, Jeff
I should reange the data and after that use a pivot table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks