Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Discussion (Misc queries) > Jululian Excel
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 89
Default Jululian Excel
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

Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 8,520
Default Jululian Excel
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

Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 89
Default Jululian Excel
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

Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 8,520
Default Jululian Excel
=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

Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 89
Default 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

Reply With QuoteReply With Quote
  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 8,520
Default Jululian Excel
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

Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Jululian Excel George A. Jululian[_2_] Excel Discussion (Misc queries) 3 November 8th 09 10:49 AM
Jululian Excel George A. Jululian[_2_] Excel Discussion (Misc queries) 2 November 7th 09 08:48 AM
Jululian & Excel George A. Jululian[_2_] Excel Discussion (Misc queries) 7 November 1st 09 01:22 PM
Excel Jululian George A. Jululian[_2_] Excel Discussion (Misc queries) 4 October 5th 09 01:19 PM
Excel Jululian George A. Jululian[_2_] Excel Discussion (Misc queries) 5 December 17th 08 05:00 PM


All times are GMT +1. The time now is 06:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement