Hi everyone,
I want to calculate the total number of days that a certain person will be working in a project from today onwards.
The formula I am using is not working though.
You can see a print screen here or in attachment: http://postimg.org/image/6ynzgfp1b/
Thanks in advance.
sumifs error.png
Last edited by xourico24; 11-10-2014 at 08:36 AM.
Hi,
You'd be better advised to upload the workbook here. Pictures are generally frowned upon (see rules area guidance) and most of us don't do dropbox type sites whose provenance may not be certain.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Your ranges must be same for SUMIF function.
Try:
Formula:
Please Login or Register to view this content.
Hi, Welcome to the forum,
Can you post a sample in excel file, rather than a picture it will be easy for us to examine
☚ Click ★ just below left if it helps, Boo?ath?
Sorry delay it posting, Solution already provide...
Here is the workbook
nodip_v1.xlsx
That formula returns the value 2. The desired result is 13 for this case. I already uploaded the workbook.
Here it is: nodip_v1.xlsxOriginally Posted by boopathiraja
It's fine for criteria >= TODAY:
Formula:Please Login or Register to view this content.
If you want to get your expected results it's for whole table, then remove last criteria:
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks