View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Reza Reza is offline
external usenet poster
 
Posts: 88
Default find the correct sum

HI EXPERTS,

i hope you and excel can do this.
i have a master data with so many rows.
i.e A B C D
No Name City Values
1 - - 100
2 - - 3081
-
5000 - - 6

now my bos ask me to find values with total sum i.e 258,000 from data above.

can excel do this, or should create program using vb?
can anybody help me?

hope you understand with what i want to achieve.

thanks

regards,
reza