I'm new to this forum and haven't use Excel in about 3 years. I set up formulas to count text characters in a range of cells. I'm tracking attendance and payments for a small yoga studio.
All I need to do is count "Y"s for prepaid attendance and "DI"s for drop-ins. I have the formulas working but they are absolute so inserting a row will break my sheet.
=COUNTIF(E14:Z14,"*Y*")
=COUNTIF(E11:Z11,"*DI*")
Can anyone point me to some written how-to docs for this? Not videos, please. Videos remind me of VHS tapes compared to DVD media.
About me: I'm retired, studying Yoga, and helping manage a small studio I study at. I was a Unix Sys Admin, database admin, Sendmail/messaging specialist in my last working incarnation.
Thank you,
Ed
Bookmarks