COUNTIF FUNCTION

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I COUNTIF values in Column A = "Manchester" AND values in column B =
"Overdue"
i.e I have a sheet with lots of locations in Column A, and Overdue or "OK"
in Column B, but i want to know how many overdues there arevfor particular
locations!
 
Hi,
To count the numbers only,try this
=countif(A1:A1000,"Manchester")+countif(B1:B1000,"Overdue")

Thanking you,
K.S.Warrier
 
Hi KS

this will give a count of ALL Manchester plus ALL overdue - not overdue in
Manchester.
i.e.
Location Status
Manchester Paid
Machester Overdue
Lincolnshire Overdue

you're formula will return 4 not 1

Cheers
JulieD
 
Another way to summarize the data is by using a pivot table. There are
instructions in Excel's help, and some instructions and links here:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

Create a pivot table with Location in the row area, and Status in the
column area. Add another copy of Location to the Data area, where it
will become Count of Location.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with suming muliple columns 5
Excel Excel due and overdue date colours 2
Deleting Rows with a macro based on a date value 2
Vlookup of an if statement return 2
countifs Function not giving desired result with date criteria 2
If Statement 2
Ignore blank cells when calculating date for If, Then function 2
Logical functions with dates and TODAY() 9

Back
Top