J
Jennifer
I have a list of dollar amounts that I'm trying to count
the number of items that match a certain production
level. Here are my levels: >=20, between 10 and 19,
between 1K and 10, and <=0. I can figure out the >=20 and
<=0 by doing a simple countif function. I've tried
combining the AND function with COUNTIF, to no avail. I
need to create the function for each level in it's own
cell, otherwise I'd just do a nested IF. Please help!
the number of items that match a certain production
level. Here are my levels: >=20, between 10 and 19,
between 1K and 10, and <=0. I can figure out the >=20 and
<=0 by doing a simple countif function. I've tried
combining the AND function with COUNTIF, to no avail. I
need to create the function for each level in it's own
cell, otherwise I'd just do a nested IF. Please help!