Tuesday, February 19, 2013

yogi_WorkAround For Excel COUNTIFS Function In A Google Spreadsheet


                                          Google Spreadsheet   Post  #1035
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 19, 2013
user James Calabrese said:(http://productforums.google.com/forum/?zx=1w1p4geyesws#!category-topic/docs/spreadsheets/0932Nyjo40E)
Countifs??
Hi,

Tried "googling" but, I'm still stumped.  Here's a formula I presently use:

=COUNTIFS(CallList!$W:$W,B$3,CallList!$M:$M,$A5,CallList!$V:$V, $A$1)
How would I make that work in spreadsheet?
Thanks!
-----------------------------------------------------------------------------------------------------------
following is a solution to the problem