Re: Calculate Filtered cells with satisfying toomany arguments..

Tech-Archive recommends: Fix windows errors by optimizing your registry

If the cell appears blank that means the formula is returning a 0 and you
probably have 0 display turned off.

--
Biff
Microsoft Excel MVP


"Manikandan" <Manikandan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E3A726D2-E747-4BD2-B022-52A231F48227@xxxxxxxxxxxxxxxx
Hi,
I have try this by changing the date fomat already and now also, but still
there is no answer in that cell(just shows blank)!!
Please help...

Manikandan

"Ashish Mathur" wrote:

Hi,

If your system is on the American date format, then 16/2/2009 will not be
recognised and that may be the cause of the incorrect answer. Therefore,
try to change the date to 2/16/2009.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Manikandan" <Manikandan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:36F8695E-BD1E-4B8F-8745-CB284715D960@xxxxxxxxxxxxxxxx
Hi,
I am very sorry, now also it is not working....there is no data in the
fomula cell(just a blank only) after changing the formula.... Please
help
sir....

Manikandan.

"Ashish Mathur" wrote:

Hi,

Please input 10/2/2009 and 16/2/2009 in cell M2 and M3 respectively
and
then
modify the formula as follows:

=SUMPRODUCT((G993:G1044="RAKESH")*(L993:L1044>=M2)*(L993:L1044<=M3),I993:I1044)

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Manikandan" <Manikandan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C7CAC29B-A8F0-472E-AC75-BF638019DEE8@xxxxxxxxxxxxxxxx
I put the formula as given by you, but it shows cell result as
#Name?
only....
I put formula as
=SUMPRODUCT((G993:G1044="RAKESH")*(L993:L1044>=10-FEB-2009)*(L993:L1044<=16-FEB-2009),I993:I1044)
is it right??? how can i put date in this formula??
Please reply...

"Manikandan" wrote:

Sir,
I am having a work*** which contains the following data. What i
required
is when i select a sales Person name by using filter, it should
show
the
total value of SO VALUE where Order Receiving date is from a
range(like
01.02.09 to 10.02.09).
How will i get this data???
P.O No. Dealer Name Sales Person SO VALUE Order Receiving
Dt.

Please Help!!!
Regards,
M.Manikandan.




.

Quantcast