Counting Dates
Column A has a a list of letters (a,b or c) and Column B has a list of random
dates. How do i get a formula that will count all letters of "a" that have a date in February for example. I am trying to use a DSUM (if this is correct), however what would be the criteria for a "date in febraury" ? |
Counting Dates
Dilly;340795 Wrote: Column A has a a list of letters (a,b or c) and Column B has a list of random dates. How do i get a formula that will count all letters of "a" that have a date in February for example. I am trying to use a DSUM (if this is correct), however what would be the criteria for a "date in febraury" ? Hi, I don't know about DSUM but the following should do =sumproduct((a1:a100="a")*(month(b1:b100)=3)) ( adapt the range to your needs but BOTH ranges must have same length) -- Pecoflyer Cheers - ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=95305 |
All times are GMT +1. The time now is 12:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com