Countifs by date and by cell value

cjjn

New Member
Joined
Feb 20, 2013
Messages
14
hello

I am trying to count vacation days booked vs taken

i have each date as acolumn header

1/1/14 1/2/14
Emp 1 1
Emp 2 2

I only want it to count if it is a 2 and if it is prior to 'today'

any ideas?
Thanks!
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
I really can't make much of the table. Could you give more ample data and what your desired output should be?
 
Upvote 0
I really can't make much of the table. Could you give more ample data and what your desired output should be?

Sorry

vacation code =2 (could also be a 1 for sick day, 3 for unpaid day etc.)

i want to count # of vacation days taken (per employee) and number of vacation days booked (per employee)

Right now I have each employee in their own row

Columns B through MR represent each day of the year

In column MS the header row is labeled Vacation days taken - for row 2 as an example I need this to be count if B1 - MR1 less than or = to today AND Row 2 = 2
In column MT the header row is labeled Vacation days booked - for row 2 as an example I need this to be count if B1 - MR1 = greater than today AND Row 2 = 2

Row 1 1/1/14 1/2/14 1/3/14 etc.
Row 2Emp1
Row 3emp2
Row 4emp3

I dont know how to make it look at both the date in Row 1 and the cell value in row 2 to count it either as booked or taken.

Hope that was more clear - sorry I dont think i am doing a great job explaining myself

Thanks
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,974
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top