Results 1 to 2 of 2

Thread: Error Handling

  1. #1
    Join Date
    Mar 2004
    Posts
    361

    Unanswered: Error Handling

    I have written this function =SUMIF(Man!AB1:AB99,"2000911 C2 Cab",Man!$S$1:$S$100)/C64 which works when there is data involved on the other worksheets. How can I return the value of 0 if there is not data that matches my criteria?

    Thanks a bunch

  2. #2
    Join Date
    Feb 2004
    Location
    Swindon, UK
    Posts
    86
    try this

    =IF(SUMIF(Man!AB1:AB99,"2000911 C2 Cab",Man!$S$1:$S$100)/C64="",0,SUMIF(Man!AB1:AB99,"2000911 C2 Cab",Man!$S$1:$S$100)/C64)

Posting Permissions

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