No place for sum

[rumkus]

To create a report from sheet1 I use below formula on sheet2

On A2

=IF(sheet1!B2="NameA",ROW(),"")

On B2 and C2 and other columns

=IF(ROW(A1)>COUNT($A:$A),"",INDEX..........................

I create all reports needed. But it starts from top.
And no place for sums.Want to leave say 5 rows
at top for report label and sums.
Instead of A2 tried to start on A7 but didn't work.
Can you advice ? Thank you.

 

[bj]

Not completely sure what you are trying to do or what your problem is, but
could you use in A7
=IF(sheet1!B2="NameA",ROW()-5,"")
I don't know what you are doing in the scond equation so no suggestions

 

[rumkus]

Thank you very much.

Now with your code on A7 I have the desired report starting from row 7
leaving me enough
space for labels and sums at top.

Great !

 

[rumkus]

Hi
Sorry. One more question.
How can I sort my list according to B column ? It is date.
(I mean with formula change)

On A7

=IF(sheet1!B2="nameA",ROW()-5,"")

On B7 and others

=IF(ROW(A1)>COUNT($A:$A),"",INDEX(sheet1!A:A,SMALL($A:$A,ROW(A1))))

 

[bj]

select row 7 and below.
data sort by column B