I am using several countif formulas to count the number of appointments each consultant has seen. So it is essentially the same formula for each consultant, just changing the name for each different one. This works for every consultant, except one! (Which happens to be mine) It doesn't count the appointments for Liz
Example of formula:
=COUNTIFS(E2:E19,"Liz",H2:H19,"1")+COUNTIFS(E2:E19,"Liz",I2:I19,"1")+COUNTIFS(E28:E36,"Liz",H28:H36,"1")+COUNTIFS(E28:E36,"Liz",I28:I36,"1")+COUNTIFS(E55:E65,"Liz",H55:H65,"1")+COUNTIFS(E55:E65,"Liz",I55:I65,"1")+COUNTIFS(E84:E93,"Liz",H84:H93,"1")+COUNTIFS(E84:E93,"Liz",I84:I93,"1")+COUNTIFS(E113:E131,"Liz",H113:H131,"1")+COUNTIFS(E113:E131,"Liz",I113:I131,"1")+COUNTIFS(E142:E163,"Liz",H142:H163,"1")+COUNTIFS(E142:E163,"Liz",I142:I163,"1")
I know it's long, i don't know how else to do it :| So this same formula works for all the other names except for "Liz" - does anyone have any ideas?
I have deleted all the Liz's in the spreadsheet and re-entered them and deleted the formula and re-done by it's not working.
Bookmarks