Hi
I need help with creating a statistics table that pulls information from mother table and provides the count of data available there. Sample table attached. Appreciate an early revert.
Thanks.
Hi
I need help with creating a statistics table that pulls information from mother table and provides the count of data available there. Sample table attached. Appreciate an early revert.
Thanks.
Some thing like the attached...
Hi and welcome to the forum
If you want to count (sum) the occurrences, use this, copied down and across...
=SUMIF($B$3:$N$3,B$11,$B4:$N4)
If you want to count (count) the occurrences, ignoring if there is a 1 03 2 in a cell, use this, copied down and across...
=COUNTIFS($B$3:$N$3,B$11,$B4:$N4,">0")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks