Re: $$Excel-Macros$$ Need VBA code for Sumifs function.

2014-03-19 Thread priti verma
amp; ",'Audit details'!" & Range("h3:h54").Address & >>> "," & Range("b3").Address(0, 1) & ",'Audit details'!" & >>> Range("b3:b54").Address & "," & Range("d2"

Re: $$Excel-Macros$$ Need VBA code for Sumifs function.

2014-03-19 Thread Prabhu Pinky
;sumifs('Audit details'!" & Range("l3:l54").Address & ",'Audit >> details'!" & Range("j3:j54").Address & "," & Range("b3").Address(0, 1) & >> ",'Audit details'!" & Range("b3:b54"

Re: $$Excel-Macros$$ Need VBA code for Sumifs function.

2014-03-19 Thread Prabhu Pinky
7;Audit details'!" & Range("l3:l54").Address & ",'Audit > details'!" & Range("j3:j54").Address & "," & Range("b3").Address(0, 1) & > ",'Audit details'!" & Range("b3:b54&q

Re: $$Excel-Macros$$ Need VBA code for Sumifs function.

2014-03-19 Thread priti verma
t;)+" & "sumifs('Audit details'!" & Range("l3:l54").Address & ",'Audit details'!" & Range("j3:j54").Address & "," & Range("b3").Address(0, 1) & ",'Audit details'!"

Fwd: $$Excel-Macros$$ Need VBA code for Sumifs function.

2014-03-18 Thread Prabhu Pinky
any experts here..??? Please help with my query. its very urgent. Thanks & Regards, Prabhu R -- Forwarded message -- From: Prabhu Pinky Date: 19 March 2014 10:41 Subject: $$Excel-Macros$$ Need VBA code for Sumifs function. To: "excel-macros@googlegroups.com"

$$Excel-Macros$$ Need VBA code for Sumifs function.

2014-03-18 Thread Prabhu Pinky
Hi experts, Please find the attached file. i almost complete my project. But struck up in sumifs part. i used formula in sheet2. but i need to have it in VBA code. i tried it but the cell reference is not changing. whatever the result i get for AAA, same value i get for other agents. most import