You could apply INDIRECT like this:
=SUMIF($C$1:$Z$1,"N",indirect("C"&A1&":Z"&A1)
where A1 will house the row number, eg: 20
Note that your SUMIF ranges should be consistent
(cols C to Z)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"sansk_23" wrote:
Thx.
Further if i have the formula for :
North as - SUMIF($C$1:$Z$1,"N",$C$19:$AA$19)
South as - SUMIF($C$1:$Z$1,"S",$C$19:$AA$19)
West as - SUMIF($C$1:$Z$1,"W",$C$19:$AA$19)
East as - SUMIF($C$1:$Z$1,"E",$C$19:$AA$19)
and for the portion "$C$19:$AA$19" from the above formulas,
i want the row no "19" as an input from another cell , ssay A1.
If i change the value of the cell A1 to 20, then the above formulae should
turn to :
North as - SUMIF($C$1:$Z$1,"N",$C$20:$AA$20)
Pls advise.