Sumproduct with last used cell

[rajpalmanish]

HI,

I am working on a file where i am using Sumproduct to calculate the sum with specific criteria.

The function used is "=SUMPRODUCT(('Peer Review'!$A$11:$A$68="01-Apr-07")*('Peer Review'!$E$11:$E$68="Dheeraj")*(IU$11:IU$68))"

Now, the data would keep adding on sheet peer review and the problem is wheneven i would add the data, i need to change the range value in formula. (Currently $A$11:$A$68).

I tried it using name range however this is not working.

I want sumproduct should always takes the data and gives sum upto new added entry.

Can anyone please provide me a solution.

Thanks

Manish

[VBA Noob]

Cross posting is not allowed unless you include the link.

This thread will now be locked

http://www.ozgrid.com/forum/showthread.php?t=66523

VBA Noob