I got a problem with my "sumif formula". I think it is very simple to fix, but I can't find a solution to it.
I want to sum a range of cells, if a single cell got the specific initials.
=sumif(M9;"IS";N9:Q9), For some reason this formula does only give the value from cell N9, and not the range, N9:Q9.
I'm sorry for bad english, but I hope you will understand me.
Thanks in advance!