Hello Guys, I've been send to this forum from a Dutch computer forum because i have a question about GoogleDocs Spreadsheet.
I have three colums. 1. with different Dates, 1 with Status (drop down menu with: "Pending", "Accepted", "Denied") and 1 with €-amouts. I have two input cells in which I fill in two dates: The Start date, The End Date. Now i which to receive different outputs: - How many rows are between Start date & End Date? - What is the total amount of all €-amounts of these rows? - How many rows with state: "Pending" are between Start date & End Date? - What is the total amount of all €-amounts of these rows (Pending state)? - How many rows with state: "Accepted" are between Start date & End Date? - What is the total amount of all €-amounts of these rows (Accepted state)? - How many rows with state: "Denied" are between Start date & End Date? - What is the total amount of all €-amounts of these rows (Denied state)? The first 1 I solved with this formula: * * *=Countif(B9:B101;">"&K4)-Countif(B9:B101;">"&K5)* Where B9:B101 = the dates, K4 is Start Date, & K5 is End date. The how many rows are Pending between Start and End date I solved in MS Excel 2010 with this formula: *=SUMPRODUCT((B9:B13>$K$4)*(B9:B13<$K$5)*(H9:H101="Pending"))** * But this doesn't seem to work in GoogleDocs SpreadSheet Can someone please help me with this? K4=Start date K5=End date B9:B101 = Date's H9:H101 = State's E9:E101 = €-Amounts Thanks in advance, Kind Regards, Joost -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
