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