Results 1 to 3 of 3

Thread: add string??

  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Harrisburg, Pennsylvania, USA
    Posts
    168
    Thanks
    1
    Thanked 0 Times in 0 Posts

    add string??

    Hello all,

    I am looking at adding cells across 31 columns to get a total dependent on criteria met. My quest is if the cell above shows a letter "p" I want the number that is recorded in the cell below to be added to the total. example... if b7 showed "P" and b8 showed 8 then nothing till f7 showed "p" again and f8 shows 6 the total should equal 14. the following shows an excerpt of a formula I tried using however, one, it only = 8 in the total column and if I remember right I can only use so many "if then" nested? so going across 31 would be to many, correct???

    Thanks in advance for any and all help,...
    =SUM(IF(B7="p",+B8,+IF(C7="p",+C8,0)))

  2. #2
    Pecoflyer
    Guest
    Perhaps =sumif(A7:X7,"p",A8:X8) adapt the ranges to your needs

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Harrisburg, Pennsylvania, USA
    Posts
    168
    Thanks
    1
    Thanked 0 Times in 0 Posts
    thanks pecoflyer... this will work !! much appreciated

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •