SUMIF with multiple sheets

Giganews Newsgroups
Subject: SUMIF with multiple sheets
Posted by:  frustratedwthis
Date: Fri, 19 May 2006

I am trying to use the following formula to sum the same cell on multiple
sheets IF the critria in another cell on each sheet matches :


I get a return of VALUE.
Can I not use SUMIF to calculate the numbers I need?
Any suggestions?