• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy

S

shibulal

Member
=DSUM('All Site All Details'!$E$2:$AO$3504,"Esc_amnt",ESCMicr!A7:B8). How to repeat the copy command with the multiplication of 2 rows in A7:B8 ? (A9:B10, A11:B12 like that)
 
Hi


are you specifying different criteria in A7:B8, A9:B10, A11:B12. It maybe easier to use Sumif with the criteria in a column
 
Hi


I am not sure how your worksheet is set up, but have consiidered using SUMIF with the criteria in a column, so that you do not require more than one row for the criteria as you would in the DSUM formula.
 
Hi shibulal,


Use this formula to get A7:B8, A9:B10 like results.

="ESCMicr!"&"A"&(ROW(A4)*2+1)&":"&"B"&(ROW(B5)*2)


But the problem i am facing is that excel is taking the final result as "Text". If it had been to use the result of final output of this formula then it would have been OK but since you need changing cell reference it is still problematic in the final stage.


Regards,

Faseeh
 
You must log in or register to reply here.
Back
Top