Formula to Count Across Rows

CaraBart28

Hello!

Checking to see if there is a way to count across rows rather than down columns. I would like to be able to identify how many times over the year the report was either sent on time, late, or not at all.

Screenshot provided for reference.

Thank you!

Report.jpg

Uploaded Oct 10, 2022228.22 KB

Michael Culley

Yea you can count across rows. You can do something like:

=countif([Jan '22 Medicaid]1:[Oct 22' Medicaid]8,"Not Received")

You can click on the starting cell and drag it to the ending cell to get the table range for the formula.

Hope this helps.