Hi
I have a pretty simple formula but it seems to be double counting or not sure what's really doing
Formula in cell F2 "Summary" sheet
=SUMIFS(Data!$L:$L,Data!$Z:$Z,Summary!G2)
for the first item labelled "<N/A>", it's showing 57K when it should be ~20K.
Can someone pls help me understand why that is? providing sample workbook.
FYI, the total in the "data" sheet is 66K, and when i total my entries in summary sheet, it shows 103K. The issue is with <N/A> label. I tried to call it "Blank" and other, but no luck.
thx in advance.
Bookmarks