COUNTIF function with conditional argument

  • Thread starter Thread starter Richard Crum
  • Start date Start date
R

Richard Crum

in Excel 2000

I want to use the COUNTIF function similar to the SUMIF
function conditioning the count on the outcome of an
argument.

eg =SUMIF($B$7:$B$118,$B134,G$7:G$118)will sum the values
in a range of Column G based on the condition in Column B.

COUNTIF does not function in this formula.

Thanks
 
I am not sure I understand? The conditions for both formulas are the same,

range,condition

then sumif add another range to sum if needed but that's it. If you need to
count values using 2 conditions you can use sumproduct

=SUMPRODUCT(--($B$7:$B$118=$B$134),--(G$7:G$118=$B$134))
 
Like Peo, I am at a loss as to your intent. COUNTIF(range,condition)
counts the number of entries in range that meet the condition. If it
had the same structure as SUMIF, i.e.,
COUNTIF(range-to-check,condition,range-to-count) how would you expect
the function to work? And how would the result be different from the
actual implementation?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top