I am using the following formula(s) to calculate different criteria entered into two different columns - for example the user would either type Blue or Red into column H and Shirts or Pants into column J:
=COUNTIF(H2:H24,"Blue")
=COUNTIF(H2:H24,"Red")
=COUNTIF(J2:J24,"Shirts")
=COUNTIF(J2:J24,"Pants")
Now I need to calculate a combination of those two columns. For instance, how would the formula be written if the cell was to produce a number for the combination of blue shirts entered? Or, blue pants, red pants... etc.
Thank you!
Bookmarks