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