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