Hi all,
I swear I've seen a way to do this before but it escapes me and I'm just not figuring it out, so hopefully someone can point me in the right direction.
Ultimately I would like a =while(a:a,month=3,countif(b:b,criteria))
I know this doesn't exist but something like that
I'm making a spreadsheet for visitor logs and I want to be able to run some metrics for it
Column A is the date, B is name, C is time in, D is time out, and E is office visited.
I want to be able to have a formula for example that would count how many people visited a particular office in February, or count how many people signed in during March. My issue seems to be counting while the date equals a certain month. I've been able to do it with a helper column where I have it do a =month(a2) and then do a =countsifs(helpercolumn, 1(for example jan), e:e, 102) and it will tell me how many people visited office 102 in January but I was hoping to do a formula without the extra column. I'm just now putting this together so I don't have a spreadsheet for it yet but can make a sample data mock up if needed.
Thanks for your help in advance.
Bookmarks