n or U Revised ?

B

Blessingspoint

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
 
P

Peo Sjoblom

One way

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

or

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

Regards,


Peo Sjoblom
 
Top