View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] rumkus@hotmail.com is offline
external usenet poster
 
Posts: 22
Default No place for sum

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.