HELP... formula and general excel question

[matt179]

Hello,

Can anybody help?


Ive created a log sheet for patients i admit in the hospital i work at, i want to know is there any way to tab directly from the end of my last text column K, to the begginnning of the next row A?

Also ive created the formula's to add up how many patients are admitted per day with a COUNTA and have this working across different pages succesfully, what i want to know is that when a patient ends up not coming in, I strikethrough their information as i still want to keep their record on the log, is there any way to write a formula to subtract anyone who has been struckthrough off my totals?

Thank you in advance

 

[matt179]

Ok:

column I has 'Specialty' data ia added in via text

column J has 'Medicine' data ia added in via text

column k has 'Surgery' and is marked with a 'X'

colmun L has the 'Did not attend'

So a patient gets admitted to either 3 and a summary page adds up the totals. Its just if a patient doesnt come in and you 'X' the DNA column i need the summary to subtract it only from that area's total.

Does that help with what im after?

 

[matt179]

I have just ammended your formula to

=COUNTA(Monday!J2:J201)-SUMPRODUCT((Monday!L2:L201="X")*(Monday!J2:J201<>""))

Seems to be working so far