Excel functions

  • Thread starter Thread starter Irina
  • Start date Start date
I

Irina

Hi everyone,

Hope somebody could help me with these problems.

Problem #1.

row 1 =DSUM(database,field,'$A4:$A5)
where A4 = "destin"; A5 = "Consolidator 1"

row 2 =DSUM(database,field,'$A6:$A7)
where A6 = "destin"; A7 = "Consolidator 2"
.....
row n =DSUM(database,field,'$An:$Am)
where An = "destin"; Am = "Consolidator n"

I waste a lot of rows for this criteria only because I do not know ho
to create it another way, I mean (A4, A6 and so on)

Problem #2

I have named several range of cells in workbook. I want to change thes
names or drop it, but I can not find the way how to do it.

Thanks in advance,

and thanks a lot for all your given advices , they were very helpful.

Have a nice week,


Irina
 
Irina,

You want to extract groups of records, Consolidator 1, Consolidator 2, etc.,
though you haven't said what you want to do with them. You may want to sort
the table on the destin field, then use Data - Subtotals. Or use a pivot
table. It will provide such calculations, such as count, sum a field, for
every group (Consolidator 1, etc.) it finds in the "destin" field. Say
more.
 
Back
Top