Excel 2002 question

Nocturnal

Lifer
Jan 8, 2002
18,927
0
76
How would I get say, cell b7 to subtract from the total of cells c4 through z4?

I tried =b7-c4:z4 and it says VALUE! in the b7 cell.

TIA.