Want to COUNTIF two different columns meet a criteria HELP!
Posted by Jeff on December 13, 2001 8:29 AM
I want to have a field calculate how many occurrences where column A = one criteria and column B = another criteria. For instance:
If the report lists a store location in one column and a inventory SKU type in another, I want to count how many times the location is "Joe" and the SKU is "Widget1" on the same row. This will tell me how many widgets Joe has.
Need help on this ASAP. Thanks so much!