ExcelBanter - array - how do I do this?????

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - array - how do I do this????? (https://www.excelbanter.com/excel-discussion-misc-queries/258757-array-how-do-i-do.html)

Bumpa

array - how do I do this?????

column A Column B
3/1/10 sallie
3/2/10 betty
3/3/10 mary
3/4/10 sallie
3/5/10 sallie
3/6/10 betty
3/7/10 sallie

count how many times sallie appears if date is less that 3/5/10
I understand the array stuff please give me a answer

Mike H

array - how do I do this?????

Hi,

Use sumproduct

=SUMPRODUCT((A1:A7<DATE(2010,3,5))*(B1:B7="sallie" ))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

"Bumpa" wrote:

column A Column B
3/1/10 sallie
3/2/10 betty
3/3/10 mary
3/4/10 sallie
3/5/10 sallie
3/6/10 betty
3/7/10 sallie

count how many times sallie appears if date is less that 3/5/10
I understand the array stuff please give me a answer

All times are GMT +1. The time now is 01:21 PM.