Good day
I am hoping someone can help me I am struggling with SUMIF formulas on a specific worksheet. Basically my sheet has a column with cellphone numbers in and another with the duration of the calls. I want to calculate the total call duration of a specific number for the period. So what i have tried is a basic sumif formula but the results stay zero. If I type in the formula as indicated on various websites and this forum i get an error message regarding the apostrophe. If i do a sumproduct formula I get an Value error. The sumif formula i am using is =SUMIF(C:C,"S1",H:H), if i use the same formula without the "" then the answer comes back as zero which is wrong.
Any ideas
Thanks
William
Bookmarks