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 :

=SUMIF('06-01:06-92'I6,NP,'06-01:06-92I8)

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

Replies