Add IF to ADDIF to count from certain date

Hi everybody,

Here's my problem: I have a sheet with all the information about what a person is doing that everybody fill themself. They have a sheet, in the first colomn they put the thing they do from a selected list, in the 2nd row they type what they do, and in the 3rd row they type how many times they work on it. I am currently counting everything they do and how many times they put in it and doing graph with the info.
I currently use the following formula:
=if(Params!B5="";"";add.if(Sommaire!C:C;[@Tāches];Sommaire!E:E))

This formulas Work. It verify if the parameter exist and then proceed to count everything in the colomn C and use the number of hours in column E (Both in another sheet called Sommaire).


Now I want to basicly do the same thing but only for the last 2 weeks. I have the date in colomn B but I can't make it work. Like you see in the following, I'm trying to use the IF command to make it work.
=if(Params!B5="";"";if(Sommaire!B5:B300>=TODAY()-14;add.if(Sommaire!C:C;[@Tāches];Sommaire!E5:E300))) (Doesn't work)

I tested the TODAY()-15 and it show the right thing so there is no problem there. I can't make it so that he only count the info in the rows that have the correct date...

If it can help I can provide a "Pseudo-Copy" of the file. I'll remove everything that isnt related to the case and post it.
Any help is welcomed.
Thx for the help.

Hi Yokoblue,

Maybe the attached WorkBook is what you want.

Please also see the "Please consider" note at the bottom of this post

Hope that helps.

Yokoblue, welcome to the forum. Thanks for amending your thread title.

Hi Yokoblue,

I must admit that I am a bit confused.

Place this formula in Cell L3, and see if that helps.

Please Login or Register  to view this content.

Enter it with Ctrl+Shift+Enter.

Else I suggest you you show me what result you desire in Cell L3. I am not familiar with foreign languages, let alone English! LOL


But I really want to try and help you.

Thx a lot for your help, ill try it asap.

Sry... It doesn't work...

The result in L3 is this : Count the number of time "Autre" appear in the column B, every time it appears, I want it to take the information in the cell E and add it.

So basically, Cell L3 should show 9 as a result. L4 should show 13.5 (As of today)

(if we look tomorrow, every information taken from the 07-29th wont be there since its past 2 weeks so L3=5 L4=13 (Since there is 4 hours worked doing "Autre" the 07-29th and .5 doing "Documentation")