I have 3 columns of information. Column A has a date (01-Jan-05), column B has a name, column C has either F, Inf, or Inv. I want a formula that will count any date in column A that is January, and column B is Adam, and column C is F.
I have 3 columns of information. Column A has a date (01-Jan-05), column B has a name, column C has either F, Inf, or Inv. I want a formula that will count any date in column A that is January, and column B is Adam, and column C is F.
=SUMPRODUCT(--(MONTH(A2:A200=1),--(B2:B200="Adam"),--(C2:C200="F"))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"AnnaV" <[email protected]> wrote in
message news:[email protected]...
>
> I have 3 columns of information. Column A has a date (01-Jan-05), column
> B has a name, column C has either F, Inf, or Inv. I want a formula that
> will count any date in column A that is January, and column B is Adam,
> and column C is F.
>
>
> --
> AnnaV
> ------------------------------------------------------------------------
> AnnaV's Profile:
http://www.excelforum.com/member.php...fo&userid=9619
> View this thread: http://www.excelforum.com/showthread...hreadid=496989
>
Put the number of the month you're looking for in D1 (Jan=1, Feb=2,
etc....),
Name in D2,
And ID's in D3,
Then try this:
=SUMPRODUCT((MONTH(A1:A100)=D1)*(B1:B100=D2)*(C1:C100=D3))
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"AnnaV" <[email protected]> wrote in
message news:[email protected]...
>
> I have 3 columns of information. Column A has a date (01-Jan-05), column
> B has a name, column C has either F, Inf, or Inv. I want a formula that
> will count any date in column A that is January, and column B is Adam,
> and column C is F.
>
>
> --
> AnnaV
> ------------------------------------------------------------------------
> AnnaV's Profile:
> http://www.excelforum.com/member.php...fo&userid=9619
> View this thread: http://www.excelforum.com/showthread...hreadid=496989
>
Try this:
=SUMPRODUCT(--(MONTH(A1:A100)=1),--(B1:B100="Adam"),--(C1:C100="F"))
And of course, change the cell ranges to match your needs.
HTH,
Elkar
"AnnaV" wrote:
>
> I have 3 columns of information. Column A has a date (01-Jan-05), column
> B has a name, column C has either F, Inf, or Inv. I want a formula that
> will count any date in column A that is January, and column B is Adam,
> and column C is F.
>
>
> --
> AnnaV
> ------------------------------------------------------------------------
> AnnaV's Profile: http://www.excelforum.com/member.php...fo&userid=9619
> View this thread: http://www.excelforum.com/showthread...hreadid=496989
>
>
It Works! It Works! It Works!
Thank You!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks