Countif(Indirect) Can't drag columns

[tkkt1111]

I need to count the number of times a range has "EA" and would like to drag this across columns to change D7:D14 to E7:14

I also need help having the range automatically skip to D12:17 when dragged down the row.

The formula below works for this range but doesn't have any of the previous capabilities. Can someone take a look?

=COUNTIF(INDIRECT("STAFFING!D6:D11"),"=EA")

[Jonmo1]

Why bother with Indirect at all?
Just use direct normal referneces, and it will incriment from D to E as expected

=COUNTIF(STAFFING!D6:D11,"EA")

Then you can use offset to make the rows incriment as dragged down

=COUNTIF(OFFSET(STAFFING!D$6:D$11,(ROWS(A$1:A1)-1)*6,0),"EA")

[tkkt1111]

I initially used INDIRECT because if I inserted another column in the sheet Staffing, the below formula would just skip the newly inserted column.
INDIRECT corrects that problem but I haven't figured out a way to drag this formula across columns.
=COUNTIF(STAFFING!D6:D11,"EA")

[Jonmo1]

Well, such is the problem with indirect.
It's a pick your poison kind of situation.
If you use indirect, you can't incriment range references without alot of extra work (yes it can be done, but is it worth the effort?).
If you don't use indirect you have to deal with references changing as columns/rows are inserted/deleted

Personally, I would go with NOT using indirect, and Re-Think the process of my sheet's data entry.
Make it so that inserting/deleting columns is not necessary.

Instead of inserting a column on the left side of your data, Paste it to the end of your data on the right.