In row 1, I have a column headers in text, such as Date, Time, Profit, Hours,
etc. Then all the following rows underneath have the corresponding data in
their specific format, such as date format, time format, currency format,
etc.

I have a bunch of formulas (mostly SUMIF and AVERAGEIF) where, for example,
if columnA (date) is February, then sum/avg columnB (profit). In the
formula, I use the whole column as a range (i.e. A:A) rather than a specific
range (i.e. A2:A100) as this list is indefinitely long. However, the column
headers in text (i.e. "Date" in text format) in row 1 of the column seems to
be affecting my formulas. Is there anyway to exclude this row of column
headers from the formulas? Can I change the column A, B, C to Date, Time,
Profit, etc?