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
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
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" <[email protected]> wrote in message
news:[email protected]...
>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
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" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
>
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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >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
> >
> >
> >
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > >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
> > >
> > >
> > >
>
>
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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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" <[email protected]> wrote in message
>> > > news:[email protected]...
>> > > >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
>> > >
>> > >
>> > >
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks