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
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
https://docs.google.com/
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 e but i would like to ignore all rows who´s b cell starts with sms
thanks
----------------------------------------------------------------------------------------------------------------------------------------
Great 2 condition solution, but something is not clear to me. In this formula, the nested IF within the SUMIF...
ReplyDeleteif(B2:B<>"SMS";E2:E)
where is the ELSE condition?
As I "parse"it, when B2:B is not "SMS" (the TRUE condition), the range is returned (E2:E) for the SUMIF to process.
When B2:B is "SMS" (the FALSE condition), what value/range is returned as the ELSE condition?
Hi TheFirstOneLast:
ReplyDeleteIn use with IF function, if the third argument is omitted it is FALSE by default.
Make It A Great One
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com