# Thread: Formula needs work (Excel 97)

1. ## 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. ## 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. ## 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
•