Syntax error .Try the below

=IF(AND('Daily Report'!F9=Statistics!B1,'Daily Report'!G9=Statistics!B2,
'Daily Report'!H9=Statistics!B3),
SUMPRODUCT((Statistics!B5:BW5="Fleet")*Statistics! B6:BW370),"")

If this post helps click Yes
---------------
Jacob Skaria


"George A. Jululian" wrote:

Dear Sir

=IF(AND('Daily Report'!F9=Statistics!B1,'Daily
Report'!G9=Statistics!B2,'Daily
Report'!H9=Statistics!B3),SUMPRODUCT((Statistics!B 5:BW5="Fleet")*Statistics!B6:BW370," "))

i need the result from Fleet column which in column c,or e,g and so on

please help


"Jacob Skaria" wrote:

Try the same formula in a new workbook with 2 sheets named as Stock and
Statistics..and with some dummy data..

If this post helps click Yes
---------------
Jacob Skaria


"George A. Jululian" wrote:

Sir,

The record exists in Sheet 'Stock' matching the criterias of B1,B2,B3 waht i
need is only the total fleet for b1,b2,b3

and second why when i enter the formula it request to upadte the link
and i know there is no links

regards


"Jacob Skaria" wrote:

I tried this...(Array entered) and gives the correct result.

If a record exists in Sheet 'Stock' matching the criterias of B1,B2,B3 then
return the total of fleet

If this post helps click Yes
---------------
Jacob Skaria


"George A. Jululian" wrote:

Dear Sir,

i amend the formula to read

=IF(ISNA(MATCH(1,(Stock!$A$3:$A$35=Statistics!B1)*
(Stock!$B$3:$B$35=Statistics!B2)*
(Stock!$C$3:$C$35=Statistics!B3),0)),"",SUMPRODUCT ((Statistics!B5:BW5="Fleet")*Statistics!B6:BW370))

and the result it gave me the all sales value and not my condition

please help


"Jacob Skaria" wrote:

Welcome and thanks for the feedback..

If this post helps click Yes
---------------
Jacob Skaria


"George A. Jululian" wrote:

You are genius

Many thanks teacher



"Jacob Skaria" wrote:

=SUMPRODUCT((Statistics!B5:BW5="fleet")*Statistics !B6:BW370)

Didnt you notice the second formula I suggested
=SUMPRODUCT((B1:G1="Fleet")*B2:G100)


If this post helps click Yes
---------------
Jacob Skaria


"George A. Jululian" wrote:

Good Morning Dear Sir,
i wrote the following

=SUMPRODUCT(("Statistics!B5:BW5),*Statistics!B6:BW 370"))
the result #VALUE!

please advice

Regards

"Jacob Skaria" wrote:

Hi George

The below formula will sum the fleet entries for the month specified in cell
A2.

=SUMPRODUCT((TEXT(A2:A100,"mmyyyy")=TEXT(A2,"mmyyy y"))*(B1:G1="Fleet"),B2:G100)


You can take out the first condition if you want a full sum of fleets
=SUMPRODUCT((B1:G1="Fleet")*B2:G100)

If this post helps click Yes
---------------
Jacob Skaria


"George A. Jululian" wrote:

Hi Dear All,

i have tabe like below
B C D E F G
Date Retail Fleet Retail Fleet Retail Fleet
01-Jan-09
02-Jan-09
03-Jan-09

i need formula to sum only the fleet sales

please help

regards