Question about Microsoft Computers & Internet

1 Answer

CountIF ORSUMIF I have a column A with repetitive dates. Column B with repetitive names Example: 05/01/09 a 05/03/09 a 05/01/09 c 05/04/09 a 05/01/09 d 05/03/09 c I want to count how many a,b,c,... I have for each date.

Posted by zineb_bou on

×

Ad

1 Answer

Fred Block

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 289 Answers

COUNTIF counts items that meet criteria. The SUMIF will "add" the amounts. I believe you want to use the COUNTIF() function.

Posted on Apr 28, 2009

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Countif formulas


Are you trying to find how many don't have a letter? If so you might try "COUNTA" instead of "COUNTIF". You could also try looking at the format of the cell your formula is in and change it to general or number.

Jul 13, 2014 | Computers & Internet

1 Answer

I am trying to automatically generate serial numbers in a excel spreadsheet. I have three columns: column A is a date code under the YWW format, column B is the first serial number 00001, and column C is...


Hi JK,
We have to use the combination of dynamic list and indirect() function.
and offcourse countif() and if().

If you need the solution from me, Please send me the sample sheet on [email protected] so that I can send you the solution sheet.

Zulfikar Ali

Apr 06, 2010 | Microsoft Office Excel 2003 for PC

1 Answer

Sum of the greatest run of negitive numbers


Hi, Not sure if this is what you have tried:
1: Assuming each run is on a different column
Run1 Run2 Run3 Run4, etc...and the maxium lenght of each column is 9 values, but each colum has a different lenght of numbers..
Then you can use:
=MAX(COUNTIF(A2:A10,"<>0"),COUNTIF(B2:B10,"<>0"), {keep adding countif for each colum).

If all runs are on the same colum, then using Pivot tables is easier. If you have a copy of your data, please post it so that I can give you the exact formula ;)

Oct 21, 2009 | Microsoft Excel for PC

3 Answers

Transforming birthdates into year codes


Here is a solution that might work for you. Please be mindful that there are several different solutions that will achieve the same thing in Excel (I am assuming Excel is your software).

1) Make sure each column in your spreadsheet has a heading.

2) Highlight (select) the column of birthdays.

3) Choose Format from the menu bar.

4) Choose Cells... from the drop-down menu.

5) For the "category", choose Custom.

6) In the "type" box, type yyyy

7) Click OK and when you return to your spreadsheet, you will see only the years displayed. However, when you try to edit a cell, you will see that the entire birth date is stored and preserved.

8) Now, highlight the entire table

9) Then, choose Data from the menu bar

10) Choose Subtotals... from the drop-down menu

11) In the "At each change in" box, choose the name of the column with the birth dates

12) In the "Use function" box, choose Count

13) Leave all other choices at their defaults

14) Click OK, and you are done.

Using this method, you can continue to enter the data as you always have. In that way, the birth date info is never actually destroyed or converted. What you are doing is simply deciding what is displayed.

I hope this helps.

Aug 02, 2009 | Microsoft Office Excel 2007

1 Answer

I have a column A with repetitive dates. Column B with repetitive names Example: 05/01/09 a 05/02/09 b 05/03/09 a 05/01/09 c 05/04/09 a 05/01/09 d 05/03/09 c I want to count how many a,b,c,... I have for...


Use 3 pivot tables, put a, b, and c in the row areas and "Count of a", "Count of b" and "Count of c" in the data sections. That will give you a count of each date for each column

Apr 28, 2009 | Microsoft Computers & Internet

1 Answer

Excel formula


Use the COUNTIF command. The COUNTIF command can count the criteria for a range of cells. Since you can only use it for one range of cells or criteria, you simply add another criteria to the formula as follows: =COUNTIF(AG1:AG5,"X")+COUNTIF(Sheet2!L1:L6,"X")

Apr 10, 2009 | Microsoft Excel for PC

3 Answers

EXCEL FORMULA PC


The solution I've used in similar situations is to create a 3rd column C with the items in column A and column B concatenated.

C2 = A2 & B2
C3 = A3 & B3
C4 = A4 & B4
etc.

Then use COUNTIF function: =COUNTIF(C:C,"FredRed Ball")

Hope this helps.

May 27, 2008 | Microsoft Excel for PC

2 Answers

Formulas


You may want COUNTIF if you're specifying criteria. For instance, if my prices are found in b3 to b7, here's a formula that will find all those that are less than 6 ($6.00):

=COUNTIF(B3:B7, "<6")

If you're using multiple criteria, such as you want to find all the prices that are greater than $5 and less than $8, the following will accomplish it. (The ABS gives you the absolute value of the result, in case the smaller number is first.)

=ABS(SUM(COUNTIF(B3:B7, ">5") - COUNTIF(B3:B7, "<8")))

Nov 06, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)

1 Answer

Multiple letters in each cell, want to add the letters and tally how many of each


Use the =COUNTIF function


For example if column a has the letters in it:


=COUNTIF(a1:a100,"a")
or
@COUNTIF(a1..a100,"a")


This will count all of the letter 'a' s in
column a from row 1 to row 100.

Mike

Oct 31, 2007 | Microsoft Excel for PC

Not finding what you are looking for?

Open Questions:

0 Answers

KYOCERA PRINTER Customer care Phone nUmber+1800 828 0294 Get easy steps to forgot or change KYOCERA PRINTER customer care rKYOCERA PRINTER via phone number 1800 828 0294 just follow some steps to recover KYOCERA PRINTER customer care while you want. In varoius conditions many people lost their account customer care and much more secure information or information may be hacked by anyone so in that case people want to configure KYOCERA PRINTER with KYOCERA PRINTER or other microsoft account services. Their are many certified officer to suggest people that how to change or rKYOCERA PRINTER KYOCERA PRINTER voicemail customer care using phone number in easy mode wih simple procedure. Hence search engine suggest many combinations to rKYOCERA PRINTER KYOCERA PRINTER customer care to rKYOCERA PRINTER or change it quickly, if you have any of them so contact to get well KYOCERA PRINTER care form us. KYOCERA PRINTER customer care rKYOCERA PRINTER not working XEROX PRINTERcustomer care rKYOCERA PRINTER phone number KYOCERA PRINTER customer care rKYOCERA PRINTER contact number KYOCERA PRINTER customer care rKYOCERA PRINTER help KYOCERA PRINTER customer care rKYOCERA PRINTER care KYOCERA PRINTER customer care rKYOCERA PRINTER wont work KYOCERA PRINTER customer care rKYOCERA PRINTER wont work KYOCERA PRINTER customer care rKYOCERA PRINTER link KYOCERA PRINTER customer care rKYOCERA PRINTER issues KYOCERA PRINTER customer care rKYOCERA PRINTER usa KYOCERA PRINTER customer care rKYOCERA PRINTER customer care service. XEROX PRINTERemail account customer care rKYOCERA PRINTER ' free KYOCERA PRINTER email customer care care ' cannot rKYOCERA PRINTER KYOCERA PRINTER email customer care ' KYOCERA PRINTER email customer care care ' KYOCERA PRINTER email customer care care download ' KYOCERA PRINTER email customer care care software ' free KYOCERA PRINTER email customer care care . KYOCERA PRINTER email customer care change, KYOCERA PRINTER email hacked customer care changed, KYOCERA PRINTER email hacked can't change customer care, change KYOCERA PRINTER email customer care on iphone, change KYOCERA PRINTER email customer care on ipad, change KYOCERA PRINTER email customer care on android, KYOCERA PRINTER email account hacked can't change customer care, how to change KYOCERA PRINTER email customer care on droid, KYOCERA PRINTER email customer care problems, KYOCERA PRINTER email customer care not working, KYOCERA PRINTER email account customer care rKYOCERA PRINTER.

Apr 04, 2019 | Microsoft Computers & Internet

0 Answers

TOSHIBA PRINTER Customer care Phone nUmber+1800 828 0294 Get easy steps to forgot or change TOSHIBA PRINTER customer care rTOSHIBA PRINTER via phone number 1800 828 0294 just follow some steps to recover TOSHIBA PRINTER customer care while you want. In varoius conditions many people lost their account customer care and much more secure information or information may be hacked by anyone so in that case people want to configure TOSHIBA PRINTER with TOSHIBA PRINTER or other microsoft account services. Their are many certified officer to suggest people that how to change or rTOSHIBA PRINTER TOSHIBA PRINTER voicemail customer care using phone number in easy mode wih simple procedure. Hence search engine suggest many combinations to rTOSHIBA PRINTER TOSHIBA PRINTER customer care to rTOSHIBA PRINTER or change it quickly, if you have any of them so contact to get well TOSHIBA PRINTER care form us. TOSHIBA PRINTER customer care rTOSHIBA PRINTER not working XEROX PRINTERcustomer care rTOSHIBA PRINTER phone number TOSHIBA PRINTER customer care rTOSHIBA PRINTER contact number TOSHIBA PRINTER customer care rTOSHIBA PRINTER help TOSHIBA PRINTER customer care rTOSHIBA PRINTER care TOSHIBA PRINTER customer care rTOSHIBA PRINTER wont work TOSHIBA PRINTER customer care rTOSHIBA PRINTER wont work TOSHIBA PRINTER customer care rTOSHIBA PRINTER link TOSHIBA PRINTER customer care rTOSHIBA PRINTER issues TOSHIBA PRINTER customer care rTOSHIBA PRINTER usa TOSHIBA PRINTER customer care rTOSHIBA PRINTER customer care service. XEROX PRINTERemail account customer care rTOSHIBA PRINTER ' free TOSHIBA PRINTER email customer care care ' cannot rTOSHIBA PRINTER TOSHIBA PRINTER email customer care ' TOSHIBA PRINTER email customer care care ' TOSHIBA PRINTER email customer care care download ' TOSHIBA PRINTER email customer care care software ' free TOSHIBA PRINTER email customer care care . TOSHIBA PRINTER email customer care change, TOSHIBA PRINTER email hacked customer care changed, TOSHIBA PRINTER email hacked can't change customer care, change TOSHIBA PRINTER email customer care on iphone, change TOSHIBA PRINTER email customer care on ipad, change TOSHIBA PRINTER email customer care on android, TOSHIBA PRINTER email account hacked can't change customer care, how to change TOSHIBA PRINTER email customer care on droid, TOSHIBA PRINTER email customer care problems, TOSHIBA PRINTER email customer care not working, TOSHIBA PRINTER email account customer care rTOSHIBA PRINTER.

Apr 04, 2019 | Microsoft Computers & Internet

0 Answers

EPSON PRINTER Customer care Phone nUmber+1800 828 0294 Get easy steps to forgot or change EPSON PRINTER customer care rEPSON PRINTER via phone number 1800 828 0294 just follow some steps to recover EPSON PRINTER customer care while you want. In varoius conditions many people lost their account customer care and much more secure information or information may be hacked by anyone so in that case people want to configure EPSON PRINTER with EPSON PRINTER or other microsoft account services. Their are many certified officer to suggest people that how to change or rEPSON PRINTER EPSON PRINTER voicemail customer care using phone number in easy mode wih simple procedure. Hence search engine suggest many combinations to rEPSON PRINTER EPSON PRINTER customer care to rEPSON PRINTER or change it quickly, if you have any of them so contact to get well EPSON PRINTER care form us. EPSON PRINTER customer care rEPSON PRINTER not working XEROX PRINTERcustomer care rEPSON PRINTER phone number EPSON PRINTER customer care rEPSON PRINTER contact number EPSON PRINTER customer care rEPSON PRINTER help EPSON PRINTER customer care rEPSON PRINTER care EPSON PRINTER customer care rEPSON PRINTER wont work EPSON PRINTER customer care rEPSON PRINTER wont work EPSON PRINTER customer care rEPSON PRINTER link EPSON PRINTER customer care rEPSON PRINTER issues EPSON PRINTER customer care rEPSON PRINTER usa EPSON PRINTER customer care rEPSON PRINTER customer care service. XEROX PRINTERemail account customer care rEPSON PRINTER ' free EPSON PRINTER email customer care care ' cannot rEPSON PRINTER EPSON PRINTER email customer care ' EPSON PRINTER email customer care care ' EPSON PRINTER email customer care care download ' EPSON PRINTER email customer care care software ' free EPSON PRINTER email customer care care . EPSON PRINTER email customer care change, EPSON PRINTER email hacked customer care changed, EPSON PRINTER email hacked can't change customer care, change EPSON PRINTER email customer care on iphone, change EPSON PRINTER email customer care on ipad, change EPSON PRINTER email customer care on android, EPSON PRINTER email account hacked can't change customer care, how to change EPSON PRINTER email customer care on droid, EPSON PRINTER email customer care problems, EPSON PRINTER email customer care not working, EPSON PRINTER email account customer care rEPSON PRINTER.

Apr 04, 2019 | Microsoft Computers & Internet

Computers & Internet Logo

Related Topics:

161 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

efs_perpends
efs_perpends

Level 3 Expert

1997 Answers

k24674

Level 3 Expert

8092 Answers

Jax Planet
Jax Planet

Level 2 Expert

923 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...