Multiple criteria help...

[iamtwon]

So I need to have Excel check one column for a particular value and then check a different column in the same row if the it found the particular value in the original column.

In the end I need it to tally up the total amount of finding x in this col/row and finding y in the next col/same row.

I've been toying with this for hours.

Heres sort of what I am talking about

if(col/row = "whatever" and col/same row = "this", return/sum/count)

Please help me!!!!

THX

-Anthony

ps noob to the forum, but not noob to excel.

[Biff]

Hi!

Try this to COUNT how many times X appears in column A and Y appears in
column B:

=SUMPRODUCT(--(A1:A100="X"),--(B1:B100="Y"))

Try this to get the SUM of column C where column A contains X and column B
contains Y:

=SUMPRODUCT(--(A1:A100="X"),--(B1:B100="Y"),C1:C100)

Biff

"iamtwon" <[email protected]> wrote in
message news:[email protected]...
>
> So I need to have Excel check one column for a particular value and then
> check a different column in the same row if the it found the particular
> value in the original column.
>
> In the end I need it to tally up the total amount of finding x in this
> col/row and finding y in the next col/same row.
>
> I've been toying with this for hours.
>
> Heres sort of what I am talking about
>
> if(col/row = "whatever" and col/same row = "this", return/sum/count)
>
> Please help me!!!!
>
> THX
>
> -Anthony
>
> ps noob to the forum, but not noob to excel.
>
>
> --
> iamtwon
> ------------------------------------------------------------------------
> iamtwon's Profile:
> http://www.excelforum.com/member.php...o&userid=34630
> View this thread: http://www.excelforum.com/showthread...hreadid=544027
>