ExcelBanter - how do count a set of values that are only in todays date

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

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

- - how do count a set of values that are only in todays date (https://www.excelbanter.com/excel-discussion-misc-queries/131340-how-do-count-set-values-only-todays-date.html)

Joe[_2_]

how do count a set of values that are only in todays date

what i need to do is count a set of values in colmn B in colmn A i will have
the date

i.e
A B

19-02-07 10
19-02-07 15
18-02-07 22

Total 25

the count of values in todays date only in colmn B

can some please advise, many thanks in advance Joe

Toppers

how do count a set of values that are only in todays date

=SUMPRODUCT((A1:A100=TODAY())*(B1:B100))

HTH

"Joe" wrote:

what i need to do is count a set of values in colmn B in colmn A i will have
the date

i.e
A B

19-02-07 10
19-02-07 15
18-02-07 22

Total 25

the count of values in todays date only in colmn B

can some please advise, many thanks in advance Joe

Joe

how do count a set of values that are only in todays date

"Joe" wrote:
Thanks the formula worked fine

what i need to do is count a set of values in colmn B in colmn A i will have
the date

i.e
A B

19-02-07 10
19-02-07 15
18-02-07 22

Total 25

the count of values in todays date only in colmn B

can some please advise, many thanks in advance Joe

Joe

how do count a set of values that are only in todays date

Thanks

"Toppers" wrote:

=SUMPRODUCT((A1:A100=TODAY())*(B1:B100))

HTH

"Joe" wrote:

what i need to do is count a set of values in colmn B in colmn A i will have
the date

i.e
A B

19-02-07 10
19-02-07 15
18-02-07 22

Total 25

the count of values in todays date only in colmn B

can some please advise, many thanks in advance Joe

All times are GMT +1. The time now is 04:26 PM.