countaif

A

A.Mourice

plz. i need a help.
How can I use countaif with many conditions or any similar formula?
 
M

Max

A.Mourice said:
How can I use countaif with many conditions or any similar formula?
Click to expand...

You can use sumproduct for multi-criteria counts
Eg in say, C1:
=SUMPRODUCT((A1:A10="Peter")*(B1:B10>50))
will return the counts of lines where col A contains: Peter
AND where col B contains numbers greater than 50
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
 
R

Rick Rothstein \(MVP - VB\)

You would use the SUMPRODUCT formula. There are two forms for it...

=SUMPRODUCT(Condition1*Condition2*etc)

or

=SUMPRODUCT(--Condition1,--Condition2,--etc)

where, for your stated question, Condition1/2/etc. are logical multi-range
expressions such as this...

(A1:A20<5)

Here is some more detailed information about SUMPRODUCT...

http://xldynamic.com/source/xld.SUMPRODUCT.html

Rick
 
F

Fred Smith

Unfortunately, Rajesh, Countif is not that smart. You need to use Sumproduct
to achieve the desired results.

Regards,
Fred.
 

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

Counting Cells w/ a certain character in them? 1
Count 1
Managing multiple jobs in a fabrication shop 0
percentage calculation 4
Excel - Wich Function should I use? 1
Resource name inside resource sheet: per person, work per hours per week 0
Conditional Formatting 3
Multiple templates with common styles 2

Top