Jason

Posts: n/a

Question about sumproduct

I understand the standard use of "SUMPRODUCT". But the following application
confused me.

=SUMPRODUCT((A1:A10="Ford")*(B1:B10="June"))

What this function does is to count the number of Fords sold in June. I have
no idea how it works based on my understanding of basic use of the function.

Any help will be appreciated.

Jason

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded 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
Question about sumproduct	bj	Excel Discussion (Misc queries)	0	April 21st 05 05:40 PM
sumproduct question	taxmom	Excel Worksheet Functions	3	April 18th 05 07:01 PM
SUMPRODUCT with date range question	Rob V	Excel Discussion (Misc queries)	1	January 31st 05 03:55 PM
SUMPRODUCT question	Daniel Bonallack	Excel Worksheet Functions	4	November 29th 04 02:03 PM
adding two sumproduct formulas together	ski2004_2005	Excel Worksheet Functions	1	November 12th 04 09:08 PM

All times are GMT +1. The time now is 10:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us