About Us

Jim Prentice[_2_]

"Per Jessen" wrote:

Hi

I think this is what you want:

=SUMPRODUCT(--($D$1:$D$65535=D1),--($B$1:$B$65535=B1))

Regards,
Per

"Jim Prentice" <Jim skrev i meddelelsen
...
I have a database built in Excel (about 3000 rows and 25 columns). The
database grows in rows daily. One of the columns (say D), lists street
addresses, another (sayB), lists the nature of the callout to that address
(three different callout reasons could occur). I have inserted a blank
column
and in this column I want to enter a formula (in each row) to give the
number
of times a callout has occurred for that address for its corresponding
reason. With just one criteria, that of how many times a callout to an
address has occurred the formula COUNTIF(D:D,Dline number) works. I am not
sure how to bring in the second criteria €“ I have been trying SUMPRODUCT
without success.

Any help would be greatly appreciated.

Thank you to both Sheeloo and Per Jessen.
The formula from Sheeloo gives a #NUM error while the one from Per Jessen
works perfectly. Thanks very much I spent hours trying to get this right.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Counting items in one column based on criteria in another column	luttona	Excel Worksheet Functions	3	June 13th 08 06:00 PM
Counting occurrence of day of week AND hour of day	Javabumb	Excel Discussion (Misc queries)	6	June 7th 08 12:19 AM
Counting entries in column based on condition in another column	RobertR	Excel Worksheet Functions	1	February 8th 07 03:54 PM
Counting occurrences in one column based on an occurrence in anoth	Jim Jackson	Excel Worksheet Functions	12	March 3rd 06 11:10 PM
Vlookup based on designated occurrence of value	bill9340	Excel Worksheet Functions	4	November 3rd 05 07:02 PM

Menu

About Us