hi all
hopefully someone out there can help.
i would like to know if anyone can figure out why my sum if function doesn't work, it seems right to me but i am also pretty computer illiterate. i'm a uni student and it's for an assignment.
it's =SUMIF(input!$B$23:$B$1754,'Processing sales'!$A$2:$A$11,input!$C$23:$C$1754
and also excel won't let me put quotation marks around my sum range; input, is this why it is not adding the values?
thanks anyone who help me and if you need more info about the sum let me know.
han
Bookmarks