Hi,
I'm trying to summarize the total hours per discipline by week from my append table to my dashboard. However, the SUMIF function isn't working correctly; it's only showing the total as '1'. Could you please help me understand what I'm doing wrong? Am I using the incorrect formula to extract the sum data?
I've attached a photo of my append table and summary dashboard for reference.
Thanks in advance for your help!
@bee The screenshots are difficult to read due to their low resolution. Better to upload your file. Remove any confidential information but leave the structure as it is.
@riny Sorry, I can't, due to confidentiality, but I have enlarged the photo. let me know if it is still not looking great.
@bee Much better, but I can't tell what's wrong. The first picture has no visible entries that comply with the criteria ("Projects" in C and a value in I). So, I don't know where the 1 comes from. Perhaps further down the column?
The attached example contains a working example of a SUMIF, but I'm not sure that this relevant to your problem. But perhaps it helps you on your way.
Can't you create a file with just the relevant sheets and columns and blank everything else?
