countif

  • Thread starter Thread starter robert
  • Start date Start date
R

robert

suppose i have two columns, a and b, i want to be able to
count how many entries meet a criteria for the values in
both column a and b. i want to be able to use a countif
function, such that it will increase 1 to the count if the
value in ax is equal to "red", for examoke and the value
in bx is > 0, where ax and bx refer to a particular row.

i know hot to use countif to check for a condition in one
column, but i could not figure out how to check the
conditions for two different columns using countif or if.

any ideas?
 
Back
Top