Thread: Excel help?
View Single Post
  #6   Report Post  
Old June 18th 17, 09:36 PM posted to uk.sci.weather
JohnD JohnD is offline
external usenet poster
 
First recorded activity by Weather-Banter: Mar 2015
Posts: 330
Default Excel help?

Well, have a look at:

https://exceljet.net/formula/sum-if-...e-not-equal-to

Maybe my previous example should have been: SUMIF(range, "TR") - I think
this approach should work but, as ever, the syntax needs to be exactly
right.