Count IF Question

[adamvr693]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hey Guys, i Want to use COUNTIF function liek this..

(Range, Criteria, [count_range]

when you use count if, it will just let you do one if statement, (range, criteria).

Basically i want to have it count one column based on a certain criteria, if a another column meets a an additional criteria. Basically the way the SUMIF command is set up.

Thanks,

-Adam

 

[Laroche J]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hey Guys, i Want to use COUNTIF function liek this..

(Range, Criteria, [count_range]

when you use count if, it will just let you do one if statement, (range,
criteria).

Basically i want to have it count one column based on a certain criteria, if a
another column meets a an additional criteria. Basically the way the SUMIF
command is set up.

Thanks,

-Adam

This would work:
=SUMPRODUCT((C1:C10>5)+0;(B1:B10>0)+0)
where C1:C10 and B1:B10 are the two ranges, with their respective
conditions. Modify for your needs.

By the way, what you wanted is not the way the SUMIF command is set up.
SUMIF makes a test on a range then adds the corresponding values from
another range. Only one test is made on the range.

What you want, I think, is count the rows where two conditions are met
simultaneously.

JL
Mac OS X 10.4.11
Office v.X 10.1.9, Office 2008 trial