Sunday, June 16, 2013

yogi_Multi-Conditional Sum And Count Of Phone Bill Entries

                                          Google Spreadsheet   Post  #1242
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jun 16, 2013
user Daniel Por (!category-topic/docs/spreadsheets/VJ5V4wPi40E)
sumif with two criterias

is there a way to have two criterias in a sumif? 

one that does not contain a value and then one that does contain a value

here you go 

sheeet 3

so basically what i want is to have m2 only show the tally for cell phone calls and not sms as well which it does currently. so i already have a sumif that goes through the range and finds the rows with the matching info in column but i would like to ignore all rows who´s b cell starts with sms