Jululian Excel

  • Thread starter Thread starter George A. Jululian
  • Start date Start date
G

George A. Jululian

Hi all,
i have table as below

A B C D E F G
Date Retail car Fleet Car Total car Retail turck Fleet Truck Total Truck

Colunm A date from January 1st till Decmebre 31
column b sales car and c also

i need formual to give total sale value for march or april

please help
 
Hi George

'Sum of sales in ColB for the month March 2009
=SUMPRODUCT((TEXT(A1:A100,"mmyyyy")="032009")*B1:B100)

'OR with query date in cell reference say(F1)
=SUMPRODUCT((TEXT(A1:A100,"mmyyyy")=TEXT(F1,"mmyyyy"))*B1:B100)

If this post helps click Yes
 
i want to thank you for your quick respones and very very very helpful

regards
 
Back
Top