Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Look up function best place | Excel Worksheet Functions | |||
Nil in Place Off #N/A | Excel Worksheet Functions | |||
This place ROX!! | Excel Discussion (Misc queries) | |||
1st, 2nd, 3rd Place etc..... | Excel Worksheet Functions | |||
Where to place PERSONAL.XLS | Excel Worksheet Functions |