Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct or countif or both...
I want to count the no of times text [No Show]appears n column C, within a
date range, where the dates are in column A & start & end dates can be entered into cells B2 & B3 respectively. rows used for dates & data are 16:3851 Tried countif & sumproduct and have come to the realisation i need specific help. the following is the last iteration of where i was going...probably way off, any help would be appreciated... =SUMPRODUCT((MATCH(C16:C3851,"No Show",0))*((A16:A3851=B2)*(A16:A3851<=B3))) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct or countif or both...
You were close. Try this:
=SUMPRODUCT(--(A16:A3851=B2),--(A16:A3851<=B3),--(C16:C3851="no show")) -- Biff Microsoft Excel MVP "peterpeter" wrote in message ... I want to count the no of times text [No Show]appears n column C, within a date range, where the dates are in column A & start & end dates can be entered into cells B2 & B3 respectively. rows used for dates & data are 16:3851 Tried countif & sumproduct and have come to the realisation i need specific help. the following is the last iteration of where i was going...probably way off, any help would be appreciated... =SUMPRODUCT((MATCH(C16:C3851,"No Show",0))*((A16:A3851=B2)*(A16:A3851<=B3))) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct or countif or both...
Simply elegant, thankyou very much, worked a treat.
and you were too kind, i was way off hehe :) "T. Valko" wrote: You were close. Try this: =SUMPRODUCT(--(A16:A3851=B2),--(A16:A3851<=B3),--(C16:C3851="no show")) -- Biff Microsoft Excel MVP "peterpeter" wrote in message ... I want to count the no of times text [No Show]appears n column C, within a date range, where the dates are in column A & start & end dates can be entered into cells B2 & B3 respectively. rows used for dates & data are 16:3851 Tried countif & sumproduct and have come to the realisation i need specific help. the following is the last iteration of where i was going...probably way off, any help would be appreciated... =SUMPRODUCT((MATCH(C16:C3851,"No Show",0))*((A16:A3851=B2)*(A16:A3851<=B3))) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct or countif or both...
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "peterpeter" wrote in message ... Simply elegant, thankyou very much, worked a treat. and you were too kind, i was way off hehe :) "T. Valko" wrote: You were close. Try this: =SUMPRODUCT(--(A16:A3851=B2),--(A16:A3851<=B3),--(C16:C3851="no show")) -- Biff Microsoft Excel MVP "peterpeter" wrote in message ... I want to count the no of times text [No Show]appears n column C, within a date range, where the dates are in column A & start & end dates can be entered into cells B2 & B3 respectively. rows used for dates & data are 16:3851 Tried countif & sumproduct and have come to the realisation i need specific help. the following is the last iteration of where i was going...probably way off, any help would be appreciated... =SUMPRODUCT((MATCH(C16:C3851,"No Show",0))*((A16:A3851=B2)*(A16:A3851<=B3))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct or countif? | Excel Discussion (Misc queries) | |||
CountIf or Sumproduct | Excel Discussion (Misc queries) | |||
COUNTIF or SUMPRODUCT | Excel Discussion (Misc queries) | |||
SUMPRODUCT/COUNTIF | Excel Discussion (Misc queries) | |||
countif, sumproduct | New Users to Excel |