Excel SUM IF OR - Microsoft Community

i trying following;

if j5 contains letter t, sum o28,031 , o33.  if not, sum o28,o29,o30,o31 , o32

i tried following , several variations stuck!  thank you!

=if(j5="t",sum(o28,o31,o33),or(sum(o28,o29,o30,o31,32)))

hi aminaap,

i trying following;

if j5 contains letter t, sum o28,031 , o33.  if not, sum o28,o29,o30,o31 , o32

i tried following , several variations stuck!  thank you!

=if(j5="t",sum(o28,o31,o33),or(sum(o28,o29,o30,o31,32)))

try:

     =if(j5="t",sum(o28,o31,o33),sum(o28,o29,o30,o31,o32))

===

regards,

norman

Office / Excel / Other/unknown / Unknown/other