Column B contains Units (DPO,ECU,AN-2) column C contains Program Names (RCM, RBM). I want to count number of times a Unit has Program.

Result example DPO has 2 RCM, 3 RBM

Can you do this using a pivot table where columns B & C are Row Fields and Count of B&C is data fields.

Posted on May 22, 2009

Hi,

a 6ya expert can help you resolve that issue over the phone in a minute or two.

best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).

click here to download the app (for users in the US for now) and get all the help you need.

goodluck!

Posted on Jan 02, 2017

Conditional formating should be able to this. But how is your data organized? (Column headers, Row headers etc.)

Oct 20, 2014 | Microsoft Excel for PC

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

Apr 28, 2009 | Microsoft Computers & Internet

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

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

create a dummy column (columnC) containing columnA&columnB

use countif at columnD to count the number of observations per combination of columnA and columnB (in particular those with blank entries in columnB).

use countif at columnD to count the number of observations per combination of columnA and columnB (in particular those with blank entries in columnB).

Sep 15, 2008 | Computers & Internet

Use Pivot table, it might help you reach your target..!!

Aug 12, 2008 | Microsoft Excel for PC

Jul 15, 2008 | Microsoft Excel for 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.

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

hi this my id :dadu_mf@rediff.com plz send excel material

Mar 25, 2008 | Microsoft Excel for PC

Jan 28, 2016 | Microsoft Excel for PC

245 people viewed this question

Usually answered in minutes!

The expected result in column D would be the number of times a Unit came up with a certain Program. If we look down columns B & C I want to know how many times, as an example, does DPO show in column B, while RCM shows in column C on the same row.

can you explain a little more?

×