Formula Writing

[Dania1215]

I am needing to write a formula that communicated through at least 3 different sheets on my spreadsheet. I'm need to write it to count a certain column in one sheet to count within a certain groups of dates on another and then divide by 60 to get hours. I have been trying to write it for hours and keep getting different VALUE or SPILLS and not getting real numbers. Can anyone help?!?

[#2]

@Dania1215 

Your formula is

First parameter is sum range

Second parameter shall be criteria range, but you use single value.

Third parameter is criteria which is the range in your case, thus formula returns an array (SPILL since there is not enough space for it)

And I'm not sure what G14K2 means in 4th parameter.

[#3]

@Sergei Baklan 

Is this still a sumif? I cannooooottt get it to work with the different sheets. 

[#4]

@Dania1215 

SUMIF() and SUMIFS() have different order in parameters, you use SUMIFS(). Same or different sheets doesn't matter if you use parameters correctly.

[#5]

@Sergei Baklan 

Thank you. I will keep trying. :( I'm about to throw the computer out of the window! Thank you!