Re: Counting Problem

Giganews Newsgroups
Subject: Re: Counting Problem
Posted by:  Dav (Dav.27l9eo_1147259402.2033@excelforum-nospam.com)
Date: Wed, 10 May 2006

This if kind of painful and i adapted it from another post for something
i did for myself, but it seems to work

=SUMPRODUCT(($A$1:$A$6<>"")/COUNTIF($A$1:$A$6,$A$1:$A$6&"")*($B$1:$B$6=G2)*($C$1:$C$6=$H$1))

where h1 contains the date
g2 contains HO

I am assuming the issue of duplicates applies to the name, hence it is
looking at column A

Regards

Dav

--
Dav
------------------------------------------------------------------------
Dav's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=27107
View this thread:http://www.excelforum.com/showthread.php?threadid=540603

Replies

None

In response to

Counting Problem posted by Becks on Wed, 10 May 2006