# Display total countif data

#### lazylilsnoop

##### New Member
Hi guys, i need help on the excel sheet.

I'm trying to display all the cloumn that replies "Y".
first step is i count total of inquiry =counta(O5:O130) [return value 110],
then for every inquiry that was responded i marked "Y".
so i use =countif(O5:O130,"Y"), it return me 52

now the question is how do i display all the 52 details only? i do not want to view the unresponded inquiry.

thanks guys

example, shrink down by 10x

 date End User Description Quote Responded 1/1/14 Mr X Y 1/1/14 Mr Y 1/1/14 Mr X 1/1/14 Mr V Y 1/1/14 Mr K 2/1/14 Mr K Y 3/1/14 Mr Y Y

<tbody>
</tbody>

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Hi guys, i need help on the excel sheet.

I'm trying to display all the cloumn that replies "Y".
first step is i count total of inquiry =counta(O5:O130) [return value 110],
then for every inquiry that was responded i marked "Y".
so i use =countif(O5:O130,"Y"), it return me 52

now the question is how do i display all the 52 details only? i do not want to view the unresponded inquiry.

thanks guys

example, shrink down by 10x

 date End User Description Quote Responded 1/1/14 Mr X Y 1/1/14 Mr Y 1/1/14 Mr X 1/1/14 Mr V Y 1/1/14 Mr K 2/1/14 Mr K Y 3/1/14 Mr Y Y

<tbody>
</tbody>

This: =SUMPRODUCT(--(O5:O130="Y"))
would yied the same as: =countif(O5:O130,"Y")

However, the sumproduct shows you in what place the "Y" occurs (which should help). I use this in combination with an INDEX-MATCH formula to get solutions.

Hi guys, i need help on the excel sheet.

I'm trying to display all the cloumn that replies "Y".
first step is i count total of inquiry =counta(O5:O130) [return value 110],
then for every inquiry that was responded i marked "Y".
so i use =countif(O5:O130,"Y"), it return me 52

now the question is how do i display all the 52 details only? i do not want to view the unresponded inquiry.

thanks guys

example, shrink down by 10x

 date End User Description Quote Responded 1/1/14 Mr X Y 1/1/14 Mr Y 1/1/14 Mr X 1/1/14 Mr V Y 1/1/14 Mr K 2/1/14 Mr K Y 3/1/14 Mr Y Y

<tbody>
</tbody>

Another Idea could be to just Sort the Range(K5:O130) on column "O", and you will the the U's as the top 52 entrys. then copy them and paste where you would like them to be. You can add a filter etc

Another Idea could be to just Sort the Range(K5:O130) on column "O", and you will the the U's as the top 52 entrys. then copy them and paste where you would like them to be. You can add a filter etc

Try the link I provided. It's an efficient set up to gather a sublist of relevant records...

Another Idea could be to just Sort the Range(K5:O130) on column "O", and you will the the U's as the top 52 entrys. then copy them and paste where you would like them to be. You can add a filter etc

huh?? dont get it.

i'm actually trying to display all the with "Y" value only, do not want to see those details where no "Y" exist.

my end product will be like this.
 Date End User Description Quote Responds 1/1/14 Mr X Y 1/1/14 Mr V Y 2/1/14 Mr K Y 3/1/14 Mr Y Y

<tbody>
</tbody>

im guessing i should use "vlookup function"
but somehow doesnt make sense.... i think

thanks

i think i got it mixed up a little.

so from previous table, I calculated how many "Y" it is. then i want to know how many of it i replied (which i will put "Y")
i would like the end result to be

 End User Jan Feb Mar Apr May A 1 B 3 C 1 D 4 E 1 F 1 5 G 2 2

<tbody>
</tbody>

i think this should make more sense....
cause my excel is like 50 over buyers

Try the link I provided. It's an efficient set up to gather a sublist of relevant records...

the link u provided is AWESOME, but i need to do for the whole 12months, so the final product will be like
 End User Jan Feb Mar Apr May A 1 B 3 C 1 D 4 E 1 F 1 5 G 2 2

<tbody>
</tbody>

Try the link I provided. It's an efficient set up to gather a sublist of relevant records...

Dit not see it was a link (did not hover mouse over it) :S

the link u provided is AWESOME, but i need to do for the whole 12months, so the final product will be like
 End User Jan Feb Mar Apr May A 1 B 3 C 1 D 4 E 1 F 1 5 G 2 2

<TBODY>
</TBODY>

Care to post the data from which this out put is derived?

Replies
2
Views
219
Replies
12
Views
2K
Replies
1
Views
252
Replies
3
Views
515
Replies
1
Views
274

1,219,806
Messages
6,150,346
Members
450,952
Latest member
Zung

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back