Question about Business & Productivity Software

1 Answer

Excel problem At the mo i am trying to get o formula to work for excel. Lets say that i want to count up all the a entries in colum B that have an yes entry on the same row in colum C ? i have been trying this for 5 hours and my hair is starting to fall out , please can you help ?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert who has answered 20 questions.


    An expert that hasĀ over 10 points.


    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 26 Answers
Re: Excel problem

Have you tried countif?

= countif(c:c, "Yes")


You may also have to do a combo:

= count(b:b) - countif(c:c "<>'Yes'")

Wher the 'Yes' is in single quotes and the entire condition is in double quotes.

Posted on Dec 06, 2007

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

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

1 Answer

I want an formula in excel to find out number of days present per month an perticular worker

Hello this is Baris,
Can you tell me more about this employee. Are you creating an excel spreadsheet to keep record of his days. Are you just getting the numbers from an outside source like a schedule.

To be able to give you an answer I will assume that you have the info already in the same spreadsheet.

Lets say Column A is the days of the month.
Column B is the information column like the hours that the employee worked. If the month has 31 days this is what you need to do.
Click on the cell B32 and type the formula
=count(B1:B31) and press enter. This will count the number off cells which have a value in it in that month.

If you provide me more info we may come up with a better solution. Hope this helps :)

Sep 24, 2009 | Microsoft Excel for PC

1 Answer

I copied the following: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Not Intersect(Target, Range(''A2:A100'')) Is Nothing Then With...

This will fix you up. You can just use the date stamp or the date and time stamp.

1 2 3 A B Formula Description (Result) =TODAY() Current date (varies) =NOW() Current date and time (varies)

Aug 23, 2009 | Microsoft Excel for PC

4 Answers

Dont understand how to use vlookup in excel 2007

This tutorial also helped me much to understand how vlookup works:

Feb 18, 2009 | Microsoft Business & Productivity Software

1 Answer


The formula in both versions is the same:


i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.

Jan 21, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Excel - Formulas!

I find this site helpfull with Excel problems:

Sep 02, 2008 | Microsoft Excel for PC

1 Answer

Problem with formulas

You may want to try =COUNT(A1:C9) for example. In brackets type the range of cells you want to count and excel will give you the number of cells that contain numbers.

Aug 19, 2008 | Business & Productivity Software

3 Answers

Excel Formula

Lets say your data (cars) is in range "D1:D21".

You need to know how many are Dodge and Ford in cell E1.

=COUNTIF(D1:D21,"Dodge") + COUNTIF(D1:D21,"Ford)

Hope this helps.

Apr 22, 2008 | Microsoft Excel for PC

1 Answer


sorry, I need a bit more information, because if as you say, column d contains text data such as RO, MO etc, then Excel can't perform a calculation such as MO*70 ?

Jan 16, 2008 | Microsoft Excel for PC

2 Answers

Duplicacy in excel sheet

Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.
Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data
Select the entire data and do an auto filter
In column F filter the data by Duplicate and delete all these rows
What remains should be unique data

Dec 19, 2007 | Business & Productivity Software

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

100 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18257 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides