RE: Question about sumproduct

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

(A1:A10="Ford") becomes a logic function equaling true for each cell A1 to
A10 which has Ford in it. and false when it does not the same logic for
(B1:B10="June")
in calculations True is treated as a 1 and false is treated as 0
if you would enter in a cell
=(A1="Ford") you would get a True or False response If however you entered
=--(A1="Ford") you will get a 1 or 0 response

A lot of people prefer to use
=SUMPRODUCT(--(A1:A10="Ford")*--(B1:B10="June"))

"Jason" wrote:

> 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
.

Relevant Pages

  • Re: how does one convert text to a formula "average(A:A)" to =average(
    ... Jason ... Atlanta, GA ... >Would prefer not having to enter = manually in each cell. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Decimal Time
    ... If you simply have 8.25 keyed into a cell, ... >Hello Jason From Steved ... >>Atlanta, GA ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: print comments with cell label or name
    ... Perhaps you want also the label at the top of ... the cell is in as well. ... Jason, ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: COUNTIF < DATE with other data in column
    ... Jason ... >Dates are nothing more than numbers in Excel, ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: min value in range
    ... >> This is why I was hoping to use a cell by cell comparison approach, ... >> Thanks, Jason ... >> Dim myrange, mytable, mysheet, mylookup, maxlongrange, mycolumn, ...
    (microsoft.public.excel.programming)