ExcelBanter - coding question

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - coding question (https://www.excelbanter.com/excel-programming/311740-coding-question.html)

No Name

coding question

=SUMIF(INDIRECT("Q"&R866&":Q"&R867),"S2",INDIRECT
("R"&R866&":R"&R867))

How do I make the "Q" and the "R" cell refences or
varabiles?

Bob Phillips[_6_]

coding question

=SUMIF(INDIRECT(A1&R866&":"&A1&A2&"867),"S2",INDIR ECT
(A2&R866&":"&A2&R867))

A1=Q, A2=R

--

HTH

RP

wrote in message
...
=SUMIF(INDIRECT("Q"&R866&":Q"&R867),"S2",INDIRECT
("R"&R866&":R"&R867))

How do I make the "Q" and the "R" cell refences or
varabiles?

All times are GMT +1. The time now is 01:50 PM.