U or N amount 1 amount 2 total Amount
------------------------------------------
U 3 3 6
N 3 2 5
U 4 3 7
------------------------------------------

Total Amount of U 13
Total Amount of N 5
------------------------------------------

This is what I am trying to do. Will that formula do this or do I need to
add something

total
"Peo Sjoblom" wrote:

=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

One way

=SUMPRODUCT((A1:A3="U")*(B1:C3))

or

=SUMPRODUCT(--(A1:A3="U"),(B1:B3+C1:C3))

Regards,


Peo Sjoblom

"Blessingspoint" wrote:

U or N amount 1 amount 2 total Amount
------------------------------------------
U 3 3 6
N 3 2 5
U 4 3 7
------------------------------------------

Total Amount of U 13
Total Amount of N 5
------------------------------------------

This is what I am trying to do. Will that formula do this or do I need to
add something

total
"Peo Sjoblom" wrote:

=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