Hey all, I'm trying to count up the number of occurrances of a specific cell value, but only under the the column with today's date for a header.
I have a range from S7:BC16 with data. In range S3:BC3 I have dates, one of which will be today's date. I want to find which column is today's date, then count up the number of times "A" appears. I could write VBA for this, but as the range is going to be moving upon inserting/deleting rows, I'd much rather prefer to use a formula.
Currently I have then just add up that again with columns T, U, V, W,.....etc. I know there is a better way to go about this, I'm just not seeing it.... any help would be greatly appreciated. Thanks!