Adding data in cells (C1:C1000) if corresponding cell A is before Today()??

[Timthetoolman]

Gday all,

I am relatively inexperienced with VBA, but not too bad with excel, and I am trying to create a holiday leave sheet for my company. I am using Excel 2013

I cannot attach anything yet, but am happy to email a test sheet with actual leave applications.

I have used the networkdays function to calculate the days between two dates (A9:B9), in C9, and then a simple sum to add all the days for annual leave in the resulting c column.

What I need to come up with is a function or something to add all the days in column A, if the corresponding date in column A is before today's date.

Essentially adding all the days actually taken, and not the future dated ones.

Any help or advice would be great.

Tim

 

[alvin-chung]

Welcome to the forum!
Is this what you're looking for?

=SUMIF(A1:A1000,"<"&TODAY(),C1:C1000)

 

[Timthetoolman]

Thanks Alvin that works perfectly...I had something similar but arranged the wrong way.

 

[alvin-chung]

You're welcome, thank you for the feedback