Hi all,
Is it possible to create a dynamic range based on the value of a cell? For example, I am trying to do something like this:
=COUNTIF(A1:A(insert cell value here), "Blue")
So my range would be A1 to A(x) where x is the number value of a predetermined cell.
This would allow my range to change dynamically depending on the value of a specific cell. Is there anyway to accomplish this?
What I am doing is this... I have a 2 column table of data. Column 1 is "Product Type" and column 2 is "Color". There are four different products and five different available colors. I need to count the number of one type of product in each color. I can easily get a total of each product, or each color, but not a total of say Product A in blue. Any recommendations?
Is it possible to create a dynamic range based on the value of a cell? For example, I am trying to do something like this:
=COUNTIF(A1:A(insert cell value here), "Blue")
So my range would be A1 to A(x) where x is the number value of a predetermined cell.
This would allow my range to change dynamically depending on the value of a specific cell. Is there anyway to accomplish this?
What I am doing is this... I have a 2 column table of data. Column 1 is "Product Type" and column 2 is "Color". There are four different products and five different available colors. I need to count the number of one type of product in each color. I can easily get a total of each product, or each color, but not a total of say Product A in blue. Any recommendations?