Sumproduct

M

Mark

I have range that has Registered, Compted, Pre-Registered, Pre-Reg. Only, in another colum I have a range that has Fri., Sat., Sun., (some attendees registered on Friday some on Saturday some on Sunday) All I want to do is count how many each day registered. I can make the piviot table give me a answer but i want something that is automatilcly updated throuought the convention. I would think i could use the countif which works on a single range but how can i work with two ranges
I entered =sumproduct(Date="Fri")*(Registered="Registered) and all it gives is "0" excell hilights the right ranges and the spelling matches the cells. Excel wants to change the )) on the end of the formula to a single ) only.
 
D

DDM

Mark, note that Bob Phillips answered your question several hours ago. Here
is his answer (with a corrected parenthesis):

=SUMPRODUCT((A1:A100="Registered")*(B1:B100="Fri"))

If you want a formula that will update automatically, you should create
dynamic range names. Look here for information on that:
http://www.contextures.com/xlNames01.html#Dynamic.
--
DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com


Mark said:
I have range that has Registered, Compted, Pre-Registered, Pre-Reg. Only,
Click to expand...
in another colum I have a range that has Fri., Sat., Sun., (some attendees
registered on Friday some on Saturday some on Sunday) All I want to do is
count how many each day registered. I can make the piviot table give me a
answer but i want something that is automatilcly updated throuought the
convention. I would think i could use the countif which works on a single
range but how can i work with two ranges?
I entered =sumproduct(Date="Fri")*(Registered="Registered) and all it
Click to expand...
gives is "0" excell hilights the right ranges and the spelling matches the
cells. Excel wants to change the )) on the end of the formula to a single )
only.
 
Top