Data Not Showing if Coming from a cell which used a Function

[thebrucekt]

Hi

Good day to all!

I've been trying for days to figure this out but was not getting any. Hope you could assist me with this:

If my data for B column Work Hours is coming from a formula like in Data where C column Work Hours is getting it by using formula "='Hours Daily'!C2" ( I tried using other functions like sumifs, vlookup but all gave the same results = not showing in B column Total Work Hours sheet. If you manually add the hours in Data sheet Column C, it would show the correct data in Total Work Hours sheet B column.)

[AliGW]

There is nothing in K4:

=SUMIFS(Data!$C$2:$C$5,Data!$B$2:$B$5,'Total Work Hours'!$B$1,Data!$A$2:$A$5,$K4)

Hence no match. What is it meant to be, that criterion?

Try this instead:

=SUMIFS(Data!$C$2:$C$5,Data!$B$2:$B$5,'Total Work Hours'!$B$1,Data!$A$2:$A$5,$A4)

[tim201110]

=SUMIFS(Data!$C$2:$C$5,Data!$B$2:$B$5,'Total Work Hours'!$B$1,Data!$A$2:$A$5,$A4)

[thebrucekt]

Hi AliGW,

Thank you for the correction and yes i fixed it. There is something weird going on but i'll fix my sample data first and update you.

[thebrucekt]

Hi tim201110,

Thank you for the correction and yes i fixed it. There is something weird going on but i'll fix my sample data first and update you.