Countif
-
- Administrator
- Posts: 78487
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Countif
Welcome to Eileen's Lounge.
If you want to do this per row, enter the following formula in V4, then fill down:
=COUNTIFS($B$3:$U$3,"TC",$B4:$U4,0)
To count the total, you can sum V4:V11. If you prefer to count the total without the individual counts per row, you can use
=SUMPRODUCT((B3:U3="TC")*(B4:U11=0))
See the attached version.
If you want to do this per row, enter the following formula in V4, then fill down:
=COUNTIFS($B$3:$U$3,"TC",$B4:$U4,0)
To count the total, you can sum V4:V11. If you prefer to count the total without the individual counts per row, you can use
=SUMPRODUCT((B3:U3="TC")*(B4:U11=0))
See the attached version.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans