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     www.energyefficientbuild.com.   Jun 16, 2013
user Daniel Por (http://productforums.google.com/forum/?zx=j9xbgzjzha3t#!category-topic/docs/spreadsheets/VJ5V4wPi40E)
sumif with two criterias
hi

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

regards
---
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

thanks
----------------------------------------------------------------------------------------------------------------------------------------