Thread: using logical functions as criteria with the SUMIF function
View Single Post
  #1   Report Post  
pfdubz
 
Posts: n/a
Default using logical functions as criteria with the SUMIF function
I have a datatable with a number of columns and I want to add all the numbers
in column "S" when the text in column "M begin with an "A". I also want to
use the same function for all the numbers in Cloumns "T", "U", "V", etc.
I have tried =SUMIF($M$3:$M$100,LEFT($M3,1)="A",S3:S100) and all I get is
"0". Any suggestions?
Reply With QuoteReply With Quote