Sumif
 

How do I add the numbers of cells in column B only if they meet the criteria
of "Monday" from column A and "Yes" from column B?

Thanks for any help!

How can you add numbers from B where B = Yes.

Assuming you meant C

=SUMPRODUCT(--(A1:A1000="Monday"),--(B1:B1000="Yes"),C1:C1000)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CheriT63" wrote in message
...
How do I add the numbers of cells in column B only if they meet the
criteria
of "Monday" from column A and "Yes" from column B?

Thanks for any help!

I apologize for being unclear.

If I have various days in column A and want to know how many "yes" responses
I have in column B to preset criteria, how would I do that. It has nothing
to do with column C.

Instead of adding numbers, I merely want to count how many cells contain the
Yes for the day. Say, how many Yes's were there for Monday? How many for
Tuesday? Etc.

Thanks again for your time.

"Bob Phillips" wrote:

How can you add numbers from B where B = Yes.

Assuming you meant C

=SUMPRODUCT(--(A1:A1000="Monday"),--(B1:B1000="Yes"),C1:C1000)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CheriT63" wrote in message
...
How do I add the numbers of cells in column B only if they meet the
criteria
of "Monday" from column A and "Yes" from column B?

Thanks for any help!

It was the add that threw me :-)

Just use
=SUMPRODUCT(--(A1:A1000="Monday"),--(B1:B1000="Yes"))
--

HTH

RP
(remove nothere from the email address if mailing direct)


"CheriT63" wrote in message
...
I apologize for being unclear.

If I have various days in column A and want to know how many "yes"
responses
I have in column B to preset criteria, how would I do that. It has
nothing
to do with column C.

Instead of adding numbers, I merely want to count how many cells contain
the
Yes for the day. Say, how many Yes's were there for Monday? How many for
Tuesday? Etc.

Thanks again for your time.

"Bob Phillips" wrote:

How can you add numbers from B where B = Yes.

Assuming you meant C

=SUMPRODUCT(--(A1:A1000="Monday"),--(B1:B1000="Yes"),C1:C1000)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CheriT63" wrote in message
...
How do I add the numbers of cells in column B only if they meet the
criteria
of "Monday" from column A and "Yes" from column B?

Thanks for any help!

And since you're looking for a total for each day, how about entering
Monday thru Friday in Column C,
From C1 to C5,
And then enter Bob's formula in D1 with these revisions:

=SUMPRODUCT(--($A$1:$A$1000=C1),--($B$1:$B$1000="Yes"))

Then drag down to copy to D5, to get each individual day's total.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Bob Phillips" wrote in message
...
It was the add that threw me :-)

Just use
=SUMPRODUCT(--(A1:A1000="Monday"),--(B1:B1000="Yes"))
--

HTH

RP
(remove nothere from the email address if mailing direct)


"CheriT63" wrote in message
...
I apologize for being unclear.

If I have various days in column A and want to know how many "yes"
responses
I have in column B to preset criteria, how would I do that. It has
nothing
to do with column C.

Instead of adding numbers, I merely want to count how many cells contain
the
Yes for the day. Say, how many Yes's were there for Monday? How many for
Tuesday? Etc.

Thanks again for your time.

"Bob Phillips" wrote:

How can you add numbers from B where B = Yes.

Assuming you meant C

=SUMPRODUCT(--(A1:A1000="Monday"),--(B1:B1000="Yes"),C1:C1000)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CheriT63" wrote in message
...
How do I add the numbers of cells in column B only if they meet the
criteria
of "Monday" from column A and "Yes" from column B?

Thanks for any help!