Counting data using countif/countifs formula

So, for that sample data, what would the results look like and where would they be?

hi Peter,assuming start in col. a, i want to counting data in column a with col. c as criteria (yes,yes & no, blank)

...

Peter_SSs said:

So, for that sample data, what would the results look like and where would they be?

Click to expand...

muhammad susanto said:

hi Peter,assuming start in col. a, i want to counting data in column a with col. c as criteria (yes,yes & no, blank)

Click to expand...

The word data in "counting data" is ambiguous.

Would you post the count answer for each of the four counting questions?

example, for "yes" criteria, total data is 2 (robert & zidan) , etc......(OP #1)

i think like this...
<style type="text/css">
table.tableizer-table {
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif
font-size: 12px;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #ccc;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style><table class="tableizer-table">
<tr class="tableizer-firstrow"><th></th><th>after formula</th></tr>
<tr><td> </td><td> </td></tr>
<tr><td>criteria</td><td>result (based on "name")</td></tr>
<tr><td>yes</td><td>2</td></tr>
<tr><td>no</td><td>1</td></tr>
<tr><td>blank</td><td>1</td></tr>
<tr><td> </td><td> </td></tr>
<tr><td>criteria</td><td>result (based on "property")</td></tr>
<tr><td>yes</td><td>4</td></tr>
<tr><td>no</td><td>1</td></tr>
<tr><td>blank</td><td>3</td></tr>
</table>

muhammad susanto said:

example, for "yes" criteria, total data is 2 (robert & zidan) , etc......(OP #1)

Click to expand...

I'm asking the answer for all, you give just one. Why not make a full effort, thinking that the answers are not necessarily so obvious to an onlooker as it's to you?

1.

=COUNTIFS(A2:A8,"?*",C2:C8,"yes")

2.

=SUM(COUNTIFS(A2:A8,"?*",C2:C8,{"yes","no"}))

3.

=COUNTIFS(A2:A8,"?*",C2:C8,"")

4.

=COUNTIFS(A2:A8,"?*",B2:B8,"?*",C2:C8,"yes")

muhammad susanto said:

i think like this...
<STYLE type=text/css>
table.tableizer-table {
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif
font-size: 12px;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #ccc;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</STYLE>

	after formula
criteria	result (based on "name")
yes	2
no	1
blank	1
criteria	result (based on "property")
yes	4
no	1
blank	3

<TBODY>
</TBODY>

Click to expand...

"Mosterd na maaltijd", as Dutch say...

hi Aladin, syukron, but for :

, not work, should be the result : 4 (pc,monitor,rose,glass)