ExcelBanter - N or U

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - N or U (https://www.excelbanter.com/excel-worksheet-functions/9405-n-u.html)

Blessingspoint

N or U

I have a form that I need to seperate Totals with a N or a U. I want to add a
line of numbers and put answers into slot A if I chose a U or slot B if I
chose a N. What would be the Function for this. Just give me a example of
something. Thanks

Peo Sjoblom

=COUNTIF(Range,"U")

Regards,

Peo Sjoblom

"Blessingspoint" wrote:

I have a form that I need to seperate Totals with a N or a U. I want to add a
line of numbers and put answers into slot A if I chose a U or slot B if I
chose a N. What would be the Function for this. Just give me a example of
something. Thanks

All times are GMT +1. The time now is 07:19 PM.