Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2002
    Location
    South Australia, Australia
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula needs work (Excel 97)

    Is there a less cumbersome state these two formulae?


    =IF(C18="Annual",C19)+IF(D18="Annual",D19)+IF(E18= "Annual",E19)+IF(F18="Annual",F19)+IF(G18="Annual" ,G19)+IF(H18="Annual",H19)+IF(I18="Annual",I19)+IF (J18="Annual",J19)+IF(K18="Annual",K19)+IF(L18="An nual",L19)+IF(M18="Annual",M19)+IF(N18="Annual",N1 9)+IF(O18="Annual",O19)+IF(P18="Annual",P19)


    =IF(C18="Carer's",C19)+IF(C18="Sick",C19)+IF(D18=" Carer's",D19)+IF(D18="Sick",D19)+IF(E18="Carer's", E19)+IF(E18="Sick",E19)+IF(F18="Carer's",F19)+IF(F 18="Sick",F19)+IF(G18="Carer's",G19)+IF(G18="Sick" ,G19)+IF(H18="Carer's",H19)+IF(H18="Sick",H19)+IF( I18="Carer's",I19)+IF(I18="Sick",I19)+IF(J18="Care r's",J19)+IF(J18="Sick",J19)+IF(K18="Carer's",K19) +IF(K18="Sick",K19)+IF(L18="Carer's",L19)+IF(L18=" Sick",L19)+IF(M18="Carer's",M19)+IF(M18="Sick",M19 )+IF(N18="Carer's",N19)+IF(N18="Sick",N19)+IF(O18= "Carer's",O19)+IF(O18="Sick",O19)+IF(P18="Carer's" ,P19)+IF(P18="Sick",P19)

    I can post the whole spreadsheet if you require.

    Kerry

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formula needs work (Excel 97)

    These should work:
    =SUMIF(C18:P18,"Annual",C19:P19)

    =SUMIF(C18:P18,"Carer's",C19:P19)+SUMIF(C18:P18,"S ick",C19:P19)

    Steve

  3. #3
    New Lounger
    Join Date
    Dec 2002
    Location
    South Australia, Australia
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula needs work (Excel 97)

    Thanks Steve - I knew there had to be a better way.

    Much appreciated.

    Kerry

Posting Permissions

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