n or U Revised ?

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