Jululian Excel
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
|