Hello everybody, i'm working on a mini data base, and i have to do some "sum" formulas, with multiple formulas, i've read some tutorials on "sumifs" formula, but i couldn't apply it on my case, thats why i will be very thankful for your help, i posted an excel file to give an exemple on what i wanna do.
Thank you so much for you help
Last edited by anasleco; 12-01-2011 at 05:31 AM.
=SUMIFS(Feuil2!$E:$E,Feuil2!$C:$C,">"&$B6,Feuil2!$D:$D,DAY($B6)&"/"&MONTH($B6))
Regards, TMS
Thank you very much TMS, it's very helpful.Originally Posted by TMShucks
You're welcome.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
ok its done
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks