Okay, this is my first post ever. I can usually find a solution for what I'm trying to do, but this one is pretty unusual.
First, I want to count the number of cells in a range that contain either a number, OR specific text (PD). To complicate it, the cells in a range aren't contiguous. To complicate it further, the sheet contains merged cells. So even though this is a very simple spreadsheet, I'm having trouble making it do one simple calculation.
Here's a snipLedgerSnip.JPG
I know, I know - there are a million ways to make this more efficient, and it's usually a bad idea to merge cells. But I'm trying to drag my low-tech employees past the 20th century use of paper ledger pages for class enrollment. This is something that visually replicates what they're used to. It has some unprotected cells, and a little conditional formatting, but no real calculation, and we can all edit and view on our shared drive. So I'm not really up for changing the format (this year).
This sheet does exactly what I want, but it'd be really handy if it would count specific cells that contain a number (indicating a payment), or "PD." In H7 is where I'd like the total. It would total these occurrences in (upper-left of merged cell) in H9, H12, H15, H18, etc. Then, at a glance, anyone could see how many paid students are in a given class that month.
Anyone know any good ways of doing this?
Bookmarks