tag:blogger.com,1999:blog-8807805591547673516.post600613392980193113..comments2024-02-28T08:14:50.756-08:00Comments on Cloud Computing -- Google Docs Way: yogi_Workaround For Countifs Function In Google SpreadsheetYogi Anandhttp://www.blogger.com/profile/10862524957172908621noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-8807805591547673516.post-33662263829629763342013-01-10T16:25:24.716-08:002013-01-10T16:25:24.716-08:00Hi prabhakaran kn:
Please explain clearly what ex...Hi prabhakaran kn:<br /><br />Please explain clearly what exactly you want to compute ...<br /><br />1) what data<br />2) formula in which cell?<br /> of which sheet? <br />3) show me your expected result<br /> along with needed logic/explanation as to why that is the correct result<br /><br />and then let us take it from there.<br /><br />Make It A Great One.<br />Cheers!<br />Yogi<br />Cloud Computing -- Google Docs Way<br />yogi--anand-consulting.blogspot.com<br /><br />Yogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-70150450722154339812013-01-09T23:34:54.841-08:002013-01-09T23:34:54.841-08:00instead of "Group 1" it should count non...instead of "Group 1" it should count non-blank cellsAnonymoushttps://www.blogger.com/profile/00506088897183606509noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-71622842878357523912012-11-19T20:36:59.082-08:002012-11-19T20:36:59.082-08:00Hi K:
I have presented an illustration for soluti...Hi K:<br /><br />I have presented an illustration for solution to the problem in my following blog post:<br /><br />yogi_WorkAround For COUNTIFS In Excel For Multi<br />http://yogi--anand-consulting.blogspot.com/2012/11/yogiworkaround-for-countifs-in-excel.html<br /><br />Please check it out to see how this works for you.<br /><br />Cheers!<br />YogiYogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-48472329255112285982012-11-19T20:15:45.700-08:002012-11-19T20:15:45.700-08:00https://docs.google.com/spreadsheet/ccc?key=0AqFQi...https://docs.google.com/spreadsheet/ccc?key=0AqFQimVCPLK_dDBqYmtHX055OXVPVFRMR2lwTng5VFE#gid=0<br /><br /><br />What I want is the count of Network Incidents closed. Can you please help me?Kranthi Kiranhttps://www.blogger.com/profile/11704073285862832562noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-9419428357695475132012-11-19T19:27:32.206-08:002012-11-19T19:27:32.206-08:00This comment has been removed by the author.Kranthi Kiranhttps://www.blogger.com/profile/11704073285862832562noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-49706636271951644802012-04-29T06:52:40.853-07:002012-04-29T06:52:40.853-07:00Hi K:
As I said in my earlier post ...
I suggest...Hi K:<br /><br />As I said in my earlier post ...<br /><br />I suggest you share your Google spreadsheet<br /><br />1) with some sample (but realistic) data<br />2) tell us what you are trying to compute <br />in which cell?<br />of which sheet?<br />3) tell us what is your expected result<br />along with needed logic/explanation as to why that is the correct result<br /><br />and then let us take it from there.<br /><br />If you do not want to share your spreadsheet in Google Docs Help forum and you want to reach out to me outside the Google Docs Help forum, contact me via www.vCita.com/yogi.anand<br /><br /><br />Cheers!<br />Yogi<br />Cloud Computing -- Google Docs Way<br />yogi--anand-consulting.blogspot.comYogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-81387621319538506042012-04-28T23:06:56.830-07:002012-04-28T23:06:56.830-07:00Ok sorry, clearly I'm a newbie with posts so p...Ok sorry, clearly I'm a newbie with posts so please bear with me, I lost all the formatting/spacing above.<br /><br />Real quick to clarify:<br />In the first set of data Column A is "Sales Person, Column B is "Status" and Column E is "Date Lead Came In".<br /><br />In the second set of data, Column B is "Sales Person", Column D is "Jan-12" (this column totals up the number of leads in January for each sales person), and Column E is for "Feb-12". <br /><br />Even though the data is all squished together I think you can get the idea.<br /><br />Thanks for your patience....Khttps://www.blogger.com/profile/14805095974172733304noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-60829591277086202912012-04-28T22:54:37.588-07:002012-04-28T22:54:37.588-07:00Hi Yogi -
Below is a sample of the data I'm w...Hi Yogi -<br /><br />Below is a sample of the data I'm working with in Excel, the "DC Sales Leads" tab I mentioned above.<br /><br /><br />Column A Column B Column E<br />Salesperson Status Date Lead Came In<br />Dan No Sale 4/2/12<br />Dan No Sale 4/4/12<br />Bobby No Thanks 4/4/12<br />Liz Open 4/4/12<br />Bobby No Sale 4/5/12<br />Dan No Sale 4/6/12<br />Liz Open 4/6/12<br />Liz No Sale 4/6/12<br /><br /><br />The new report I'm trying to create is to track how many leads each sales person handled each month. In Excel I used COUNTIFS to make the new report by month, but Google docs doesn't support COUNTIFS so I'm now looking for an alternative. <br /><br />Below is a sample of the new report I created in Excel pulling from the data above and using COUNTIFS, but I can't get it to work in Google Docs.<br /> <br /><br />Number of New Leads Per Sales Person by Month<br /><br />Column B Column D Column E<br />Sales Person Jan-12 Feb-12<br /><br />Dan 15 24<br />Bob 23 31<br />Liz 26 28<br /><br /><br />Thank you for reading through all this! I know it must be hard to help when you don't have all the context behind the posts.Khttps://www.blogger.com/profile/14805095974172733304noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-50258344920231841192012-04-28T07:15:25.982-07:002012-04-28T07:15:25.982-07:00Hi K:
I suggest you share your Google spreadsheet...Hi K:<br /><br />I suggest you share your Google spreadsheet<br /><br />1) with some sample (but realistic) data<br />2) tell us what you are trying to compute <br /> in which cell?<br /> of which sheet?<br />3) tell us what is your expected result<br /> along with needed logic/explanation as to why that is the correct result<br /><br />and then let us take it from there.<br /><br />Cheers!<br />Yogi<br />Cloud Computing -- Google Docs Way<br />yogi--anand-consulting.blogspot.comYogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-78556761485759537632012-04-27T20:12:00.563-07:002012-04-27T20:12:00.563-07:00Sorry, one clarification on the above post...
The...Sorry, one clarification on the above post...<br /><br />The "DC Sales Leads" tab contains SALES PEOPLE (column A) and the DATES that leads came in(Column E). Now I need to track this data on a monthly basis by sales person. <br /><br />Thanks!Khttps://www.blogger.com/profile/14805095974172733304noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-20551537046051185672012-04-27T10:45:47.371-07:002012-04-27T10:45:47.371-07:00Hi, I have a similar problem trying to get a Count...Hi, I have a similar problem trying to get a Countifs calculation in Excel to work in Google Docs and I can't get it to work. Here's the Excel calculation and then I'll explain:<br /><br /><br />=COUNTIFS('DC Sales Leads'!$E$2:$E$999,"<"&E$2,'DC Sales Leads'!$A$2:$A$999,$B5)-COUNTIFS('DC Sales Leads'!$E$2:$E$999,"<"&D$2,'DC Sales Leads'!$A$2:$A$999,$B5)<br /><br /><br />The "DC Sales Leads" tab contains sales people (column A), dates (Column E), and the number of leads that have come in. I am trying to capture the data on a monthly basis by sales person. <br /><br />In the above calculation E$2 is February 2012 and D$2 is January 2012, and $B5 refers specifically to sales person, John.<br /><br />I think that I need to translate the above Excel calculation into an Array Formula to get it to work in Google Docs but I can't figure it out. <br /><br />Can you help?Khttps://www.blogger.com/profile/14805095974172733304noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-14526034582473594102012-04-10T11:40:20.675-07:002012-04-10T11:40:20.675-07:00I am glad you found the information in this blog p...I am glad you found the information in this blog post to be very informative ... Now Let Us Keep Googling.<br /><br />Cheers!<br />YogiYogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-86035882835517654032012-04-09T23:14:24.901-07:002012-04-09T23:14:24.901-07:00Thank you,
The information you shared is very info...Thank you,<br />The information you shared is very informative<br />Here’s what a business leader must know.<br />Power of <a href="https://tools.cisco.com/gdrp/coiga/showsurvey.do?surveyCode=7472&ad_id=IN-FY12Q3-PWCC&keyCode=216513_1" rel="nofollow">Cloud Computing</a>No Namehttps://www.blogger.com/profile/18088563579757397517noreply@blogger.com