Formula situation

[Steved]

Hello from Steved

=SUMIF(ParadoxRemaining!$F$2:$F$1000,"1-City",H2:H1000)

The above formula is giving me no value in the cell

=SUMIF($F$2:$F$1000,"1-City",H2:H1000)

The above formula works in SheetParadoxRemaining

What is required please to have it working in another
Worksheet.

Thankyou.

 

[JE McGimpsey]

Try:


=SUMIF(ParadoxRemaining!$F$2:$F$1000,"1-City",ParadoxRemaining!H2:H1000)

 

[Steved]

Works like a gem

Thanks very much.

-----Original Message-----
Try:


=SUMIF(ParadoxRemaining!$F$2:$F$1000,"1- City",ParadoxRemaining!H2:H1000)




.