Hi there, I’m looking to get help with 2 formulas. The issue with both is that I want to drag down the formula VERTICALLY, but the reference cells are horizontal.

Both formulas are for the “Summary Sold” tab.

First formula for Column B:

=COUNTIFS('BLSPLS Menu'!C12:C13,”*”,’BLSPLS Menu'!C12:C13,”<> ")

The formula I’m looking to create here is that I want it to count the number of cells from C12:C13 in BLSPLS Menu tab that have text in it.

Cell B3 in Summary Sold returns the correct value 2. HOWEVER, the issue I’m having down is dragging down the formula to the rest of the column, as the C12:C13 value is shifting incorrectly.

I’ve tried adding in $ to lock the values, but that doesn’t seem to help… any ideas on what other formulas I’ll need to do and how I can integrate it? I’ve read online something about INDEX?? But not sure if that’s applicable here

Second Formula for Column A:

=TRANSPOSE(CONCATENATE(INDEX('BLSPLS Menu'!$C$12:$G$13,1,1),INDEX('BLSPLS Menu'!$C$12:$G$13,2,1)))

The formula I’m looking to create here is that I want it to concatenate rows 12-13 for each column into the cell in Summary Sold.

For example, Program abc in Summary Sold Tab has spit out the correct. Value in cell C3. However, when I drag that formula down, again it does not appear to work.

For reference, Program def should combine the text from D12:D13, but it does not.

Help would be appreciated with the formulas!!! THANK YOU!

## Bookmarks