ExcelBanter - COUNTIF

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - COUNTIF (https://www.excelbanter.com/excel-discussion-misc-queries/168275-countif.html)

Mac

COUNTIF

I have this spreadsheet that I created to count activities for the day. I
added a drop down for specific choices so I can graph the results for example
Item A, Item B, and Item C. There is a total of the number of Item A's on
another sheet using the COUNTIF. How can I count numbers next to the Item A
or Item B?

Item A listed 10 times will display the number 10 using the CountIF. If
Item A has a 2 next to it, then I will need to display 20. Is there a way of
doing this?

RagDyeR

COUNTIF

Will each item have the exact same value on each row?

What/where is your list of values for each item?

If you have a datalist with these values, you can incorporate a Vlookup()
function to multiply it's return by the Countif() function.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mac" wrote in message
...
I have this spreadsheet that I created to count activities for the day. I
added a drop down for specific choices so I can graph the results for
example
Item A, Item B, and Item C. There is a total of the number of Item A's on
another sheet using the COUNTIF. How can I count numbers next to the Item
A
or Item B?

Item A listed 10 times will display the number 10 using the CountIF. If
Item A has a 2 next to it, then I will need to display 20. Is there a way
of
doing this?

Mac

COUNTIF

No, each item will not always have the exact same value.

Sheet 5
Colume 3 Column 4
Item A .....2
Item A .....3
Item B......1
Item B......5
Item A......1

Sheet 2

col 2 labeled Item A
=countif(sheet5!F3:F100,"Item A")
the above will return 3 for Item A

col 3 labeled total number

total number of Item A's in col 4 on Sheet 5
I would like for it to display 6.

How?

"RagDyer" wrote:

Will each item have the exact same value on each row?

What/where is your list of values for each item?

If you have a datalist with these values, you can incorporate a Vlookup()
function to multiply it's return by the Countif() function.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mac" wrote in message
...
I have this spreadsheet that I created to count activities for the day. I
added a drop down for specific choices so I can graph the results for
example
Item A, Item B, and Item C. There is a total of the number of Item A's on
another sheet using the COUNTIF. How can I count numbers next to the Item
A
or Item B?

Item A listed 10 times will display the number 10 using the CountIF. If
Item A has a 2 next to it, then I will need to display 20. Is there a way
of
doing this?

RagDyeR

COUNTIF

That's easy!

In column next to the Countif(), use Sumif().

=Sumif(sheet5!F3:F100,"Item A",sheet5!G3:G100)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mac" wrote in message
...
No, each item will not always have the exact same value.

Sheet 5
Colume 3 Column 4
Item A .....2
Item A .....3
Item B......1
Item B......5
Item A......1

Sheet 2

col 2 labeled Item A
=countif(sheet5!F3:F100,"Item A")
the above will return 3 for Item A

col 3 labeled total number

total number of Item A's in col 4 on Sheet 5
I would like for it to display 6.

How?

"RagDyer" wrote:

Will each item have the exact same value on each row?

What/where is your list of values for each item?

If you have a datalist with these values, you can incorporate a Vlookup()
function to multiply it's return by the Countif() function.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mac" wrote in message
...
I have this spreadsheet that I created to count activities for the day.
I
added a drop down for specific choices so I can graph the results for
example
Item A, Item B, and Item C. There is a total of the number of Item A's
on
another sheet using the COUNTIF. How can I count numbers next to the
Item
A
or Item B?

Item A listed 10 times will display the number 10 using the CountIF.
If
Item A has a 2 next to it, then I will need to display 20. Is there a
way
of
doing this?

Mac

COUNTIF

Cool! It's working...

"Mac" wrote:

No, each item will not always have the exact same value.

Sheet 5
Colume 3 Column 4
Item A .....2
Item A .....3
Item B......1
Item B......5
Item A......1

Sheet 2

col 2 labeled Item A
=countif(sheet5!F3:F100,"Item A")
the above will return 3 for Item A

col 3 labeled total number

total number of Item A's in col 4 on Sheet 5
I would like for it to display 6.

How?

"RagDyer" wrote:

Will each item have the exact same value on each row?

What/where is your list of values for each item?

If you have a datalist with these values, you can incorporate a Vlookup()
function to multiply it's return by the Countif() function.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mac" wrote in message
...
I have this spreadsheet that I created to count activities for the day. I
added a drop down for specific choices so I can graph the results for
example
Item A, Item B, and Item C. There is a total of the number of Item A's on
another sheet using the COUNTIF. How can I count numbers next to the Item
A
or Item B?

Item A listed 10 times will display the number 10 using the CountIF. If
Item A has a 2 next to it, then I will need to display 20. Is there a way
of
doing this?

Mac

COUNTIF

RagDyeR

COUNTIF

Appreciate the feed-back.
--

Regards,

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

"Mac" wrote in message
...
Cool! It's working...

"Mac" wrote:

No, each item will not always have the exact same value.

Sheet 5
Colume 3 Column 4
Item A .....2
Item A .....3
Item B......1
Item B......5
Item A......1

Sheet 2

col 2 labeled Item A
=countif(sheet5!F3:F100,"Item A")
the above will return 3 for Item A

col 3 labeled total number

total number of Item A's in col 4 on Sheet 5
I would like for it to display 6.

How?

"RagDyer" wrote:

Will each item have the exact same value on each row?

What/where is your list of values for each item?

If you have a datalist with these values, you can incorporate a
Vlookup()
function to multiply it's return by the Countif() function.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit
!
---------------------------------------------------------------------------
"Mac" wrote in message
...
I have this spreadsheet that I created to count activities for the day.
I
added a drop down for specific choices so I can graph the results for
example
Item A, Item B, and Item C. There is a total of the number of Item
A's on
another sheet using the COUNTIF. How can I count numbers next to the
Item
A
or Item B?

Item A listed 10 times will display the number 10 using the CountIF.
If
Item A has a 2 next to it, then I will need to display 20. Is there a
way
of
doing this?

All times are GMT +1. The time now is 02:14 PM.