Hi
I have a fairly simple spreadsheet that i need a little help with.
column J has either north or south written in. Column K has numbers.
1. I need to sum all non blanks of column K if column J equals north/south.
2. I need to average the non blanks of column K that only are against column J north/south.
Many thanks for your help!
Bookmarks