amp; ",'Audit details'!" & Range("h3:h54").Address &
>>> "," & Range("b3").Address(0, 1) & ",'Audit details'!" &
>>> Range("b3:b54").Address & "," & Range("d2"
;sumifs('Audit details'!" & Range("l3:l54").Address & ",'Audit
>> details'!" & Range("j3:j54").Address & "," & Range("b3").Address(0, 1) &
>> ",'Audit details'!" & Range("b3:b54"
7;Audit details'!" & Range("l3:l54").Address & ",'Audit
> details'!" & Range("j3:j54").Address & "," & Range("b3").Address(0, 1) &
> ",'Audit details'!" & Range("b3:b54&q
t;)+" &
"sumifs('Audit details'!" & Range("l3:l54").Address & ",'Audit details'!" &
Range("j3:j54").Address & "," & Range("b3").Address(0, 1) & ",'Audit
details'!"
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"
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