Need Help With Formula

  • Thread starter Thread starter Israel Rodriguez
  • Start date Start date
I

Israel Rodriguez

I'm trying to set up a formula using values on one worksheet to sum up
values on a second worksheet.
The first worksheet has these 3 columns, A, B and C where A has these
team/unit numbers (often repeating), B has one of 5 text values, while C has
a yes or no value aka "accepted" or "rejected".
Referring to sheet one, on the second sheet, one formula sums up all the
times that a team/unit has a value in B other than " ".
The second formula sums up all the times that a team/unit has "Accepted" in
column C.
I haven't been able to figure this one out.
Can anyone help?


--

Israel Rodriguez

http://www.tehawk.com
http://home.earthlink.net/~tehawk
 
Do you really put spaces in B?

=SUMPRODUCT(--(Sheet1!A2:A200="team1"),--(Sheet1!B2:B200<>" "))

if you meant blank cells

=SUMPRODUCT(--(Sheet1!A2:A200="team1"),--(Sheet1!B2:B200<>""))

2.

=SUMPRODUCT(--(Sheet1!A2:A200="team1"),--(Sheet1!C2:C200="yes"))

This assumes you want to count the individual teams/units otherwise you can
just count the yes with

=COUNTIF(Sheet1!C2:C200,"yes")

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Do you really put spaces in B?

=SUMPRODUCT(--(Sheet1!A2:A200="team1"),--(Sheet1!B2:B200<>" "))

if you meant blank cells
Click to expand...
That's what I meant.
=SUMPRODUCT(--(Sheet1!A2:A200="team1"),--(Sheet1!B2:B200<>""))

2.

=SUMPRODUCT(--(Sheet1!A2:A200="team1"),--(Sheet1!C2:C200="yes"))

This assumes you want to count the individual teams/units otherwise you
can just count the yes with

=COUNTIF(Sheet1!C2:C200,"yes")

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
Click to expand...

Thanks.
It worked the way I needed it to.


--

Israel Rodriguez

http://www.tehawk.com
http://home.earthlink.net/~tehawk
 
Back
Top