Jululian Excel
 

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

Jululian Excel
 

Hi George

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

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

If this post helps click Yes
---------------
Jacob Skaria


"George A. Jululian" wrote:

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

Jululian Excel
 

i want to thank you for your quick respones and very very very helpful

regards

"Jacob Skaria" wrote:

Hi George

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

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

If this post helps click Yes
---------------
Jacob Skaria


"George A. Jululian" wrote:

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

Jululian Excel
 

Welcome and thanks for your feedback.

If this post helps click Yes
---------------
Jacob Skaria


"George A. Jululian" wrote:

i want to thank you for your quick respones and very very very helpful

regards

"Jacob Skaria" wrote:

Hi George

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

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

If this post helps click Yes
---------------
Jacob Skaria


"George A. Jululian" wrote:

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