|
|
|
|
|
|
|
|
|
|
| |
We are giving coupons for objectives met. They have to have 2 objectives met
to earn 1 coupon, and all 3 objectives met to earn 2 coupons, otherwise, the
cell of the row (countif calculation) would return a zero.
In column "T", my formula for each row is:
=IF(COUNTIF(B266:D266,"X")=3,"2",IF(COUNTIF(B266:D266,"x")=2,"1","0"))
At the column end, I input =SUM(T3:T279) to add all the results of the above
calculation. It returns a zero even though there are several cells with 1's
and 2's.
Thanks,
Cheri
"Trevor Shuttleworth" wrote:
> Cheri
>
> Should work. What happens ? Or what doesn't happen ... OK, yeah, you
> don't get a sum. What do you get ?
>
> Regards
>
> Trevor
>
>
> "Cheri" <Cheri@discussions.microsoft.com> wrote in message
> news:E92F0404-FE81-4497-890A-DD4B1E18EECA@microsoft.com...
> >I have columns that return the countif value but cannot for some reason
> >then
> > add up those values by using the sum function. How would I do this. I
> > know
> > it should be easy but I am at a loss!
> >
> > Thank you,
> > Cheri
>
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
|
|
| |
 Answer |
|
| |
Try *removing* the quotes from around your numbers.
=IF(COUNTIF(B266:D266,"X")=3,2,IF(COUNTIF(B266:D266,"x")=2,1,0))
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Cheri" <Cheri@discussions.microsoft.com> wrote in message
news:921324C3-8045-43C9-98A6-A679A47CD36D@microsoft.com...
> We are giving coupons for objectives met. They have to have 2 objectives
met
> to earn 1 coupon, and all 3 objectives met to earn 2 coupons, otherwise,
the
> cell of the row (countif calculation) would return a zero.
>
> In column "T", my formula for each row is:
>
> =IF(COUNTIF(B266:D266,"X")=3,"2",IF(COUNTIF(B266:D266,"x")=2,"1","0"))
>
> At the column end, I input =SUM(T3:T279) to add all the results of the
above
> calculation. It returns a zero even though there are several cells with
1's
> and 2's.
>
> Thanks,
> Cheri
>
>
>
>
> "Trevor Shuttleworth" wrote:
>
> > Cheri
> >
> > Should work. What happens ? Or what doesn't happen ... OK, yeah, you
> > don't get a sum. What do you get ?
> >
> > Regards
> >
> > Trevor
> >
> >
> > "Cheri" <Cheri@discussions.microsoft.com> wrote in message
> > news:E92F0404-FE81-4497-890A-DD4B1E18EECA@microsoft.com...
> > >I have columns that return the countif value but cannot for some reason
> > >then
> > > add up those values by using the sum function. How would I do this.
I
> > > know
> > > it should be easy but I am at a loss!
> > >
> > > Thank you,
> > > Cheri
> >
> >
> >
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
Too funny! I JUST figured it out and was coming back to admit my error.
Thanks!!!
"RagDyer" wrote:
> Try *removing* the quotes from around your numbers.
>
> =IF(COUNTIF(B266:D266,"X")=3,2,IF(COUNTIF(B266:D266,"x")=2,1,0))
>
> --
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Cheri" <Cheri@discussions.microsoft.com> wrote in message
> news:921324C3-8045-43C9-98A6-A679A47CD36D@microsoft.com...
> > We are giving coupons for objectives met. They have to have 2 objectives
> met
> > to earn 1 coupon, and all 3 objectives met to earn 2 coupons, otherwise,
> the
> > cell of the row (countif calculation) would return a zero.
> >
> > In column "T", my formula for each row is:
> >
> > =IF(COUNTIF(B266:D266,"X")=3,"2",IF(COUNTIF(B266:D266,"x")=2,"1","0"))
> >
> > At the column end, I input =SUM(T3:T279) to add all the results of the
> above
> > calculation. It returns a zero even though there are several cells with
> 1's
> > and 2's.
> >
> > Thanks,
> > Cheri
> >
> >
> >
> >
> > "Trevor Shuttleworth" wrote:
> >
> > > Cheri
> > >
> > > Should work. What happens ? Or what doesn't happen ... OK, yeah, you
> > > don't get a sum. What do you get ?
> > >
> > > Regards
> > >
> > > Trevor
> > >
> > >
> > > "Cheri" <Cheri@discussions.microsoft.com> wrote in message
> > > news:E92F0404-FE81-4497-890A-DD4B1E18EECA@microsoft.com...
> > > >I have columns that return the countif value but cannot for some reason
> > > >then
> > > > add up those values by using the sum function. How would I do this.
> I
> > > > know
> > > > it should be easy but I am at a loss!
> > > >
> > > > Thank you,
> > > > Cheri
> > >
> > >
> > >
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
Cheri
it's often the way that explaining something to someone else means you look
more closely and see for yourself what the problem is.
Thanks to RD for jumping in with the answer. I knew that ;-)
Regards
Trevor
"Cheri" <Cheri@discussions.microsoft.com> wrote in message
news:2C51C4B5-3746-4847-88E1-1923BFEDC8CA@microsoft.com...
> Too funny! I JUST figured it out and was coming back to admit my error.
> Thanks!!!
>
> "RagDyer" wrote:
>
>> Try *removing* the quotes from around your numbers.
>>
>> =IF(COUNTIF(B266:D266,"X")=3,2,IF(COUNTIF(B266:D266,"x")=2,1,0))
>>
>> --
>> HTH,
>>
>> RD
>> ==============================================
>> Please keep all correspondence within the Group, so all may benefit!
>> ==============================================
>>
>>
>> "Cheri" <Cheri@discussions.microsoft.com> wrote in message
>> news:921324C3-8045-43C9-98A6-A679A47CD36D@microsoft.com...
>> > We are giving coupons for objectives met. They have to have 2
>> > objectives
>> met
>> > to earn 1 coupon, and all 3 objectives met to earn 2 coupons,
>> > otherwise,
>> the
>> > cell of the row (countif calculation) would return a zero.
>> >
>> > In column "T", my formula for each row is:
>> >
>> > =IF(COUNTIF(B266:D266,"X")=3,"2",IF(COUNTIF(B266:D266,"x")=2,"1","0"))
>> >
>> > At the column end, I input =SUM(T3:T279) to add all the results of the
>> above
>> > calculation. It returns a zero even though there are several cells
>> > with
>> 1's
>> > and 2's.
>> >
>> > Thanks,
>> > Cheri
>> >
>> >
>> >
>> >
>> > "Trevor Shuttleworth" wrote:
>> >
>> > > Cheri
>> > >
>> > > Should work. What happens ? Or what doesn't happen ... OK, yeah,
>> > > you
>> > > don't get a sum. What do you get ?
>> > >
>> > > Regards
>> > >
>> > > Trevor
>> > >
>> > >
>> > > "Cheri" <Cheri@discussions.microsoft.com> wrote in message
>> > > news:E92F0404-FE81-4497-890A-DD4B1E18EECA@microsoft.com...
>> > > >I have columns that return the countif value but cannot for some
>> > > >reason
>> > > >then
>> > > > add up those values by using the sum function. How would I do
>> > > > this.
>> I
>> > > > know
>> > > > it should be easy but I am at a loss!
>> > > >
>> > > > Thank you,
>> > > > Cheri
>> > >
>> > >
>> > >
>>
>>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
Question
Notify me of replies