What am I doing wrong with this thing?
it all seems to line up in "insert function" but when I press enter it says to check insert function or add an apostrophe if I'm not trying to type a function.
trying to sum column E if first letter in column A is "A"
Thanks,
Jordan
Code:
=sumif(left(a6:a60, 1), "A", E6:E60)
it all seems to line up in "insert function" but when I press enter it says to check insert function or add an apostrophe if I'm not trying to type a function.
trying to sum column E if first letter in column A is "A"
Thanks,
Jordan