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?