Tag: use of sumif in excel

DEFINITION :- SUMIF is a inbuilt function in excel which sum up the multiple values in a proper range with proper given criteria. TIME function is also a inbuilt function which used to measure the time or display the time in excel. In this example we will use SUMIF function to sump up the time values from a different cell on a particular criteria. To know more about sumif and sumifs please check this post SUMIF IN EXCEL & Also SUMIFS IN EXCEL NOTE:- Make sure you have time format set for the output cell. please check the image below.