|
|
#4
04-17-2023, 10:17 PM
|
|||
|
|||
Sorry! Of course the function must be IF()!
Did you try the SUMIFS() part - without checking for zero sums. It will return 0 for cases, where no date was entered for course for this student, and when formatted as date, it will be displayed as date like 0.01.1900. This my be confusing, so I added the IF() part. When this will not work, my 1st quess will be, the dates in your SourceDateRange aren't dates at all, but datestrings. Btw, I add an example! 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Keeping the source format when extracting data from multiple cells using Vlookup function
|
praboos2001 | Excel | 6 | 11-15-2016 04:40 AM |
| Multiple found values from five sheets, multiple returned values in sheet six? | irisha | Excel Programming | 26 | 09-30-2016 01:20 AM |
|
VLookup multiple values and Sum
|
tinfanide | Excel | 2 | 09-02-2014 11:41 AM |
| Using vlookup with the IF function | CSzoke | Excel | 11 | 06-01-2013 10:56 PM |
|
Is this possible using the Vlookup or any other function?
|
Delson | Excel | 4 | 02-08-2010 01:27 PM |
Windows 8 
Office 2016
Threaded Mode