Sum numbers in a particular day

[sunshine82]

Hi All,

I have dates in column a and numbers in column B.

I need a formula to look at today's date in column A and then based on today's date count the numbers in column B.

Sorry not sure if I've made any sense!

Thanks,
Sham.

[zbor]

Do you want to COUNT numbers or SUM numbers?

This is for SUM (as per title):

Please Login or Register  to view this content.

[Phuocam]

Try this ...

=SUMIF(A:A,TODAY(),B:B)

[sunshine82]

Sorry I want it to count the numbers

so for example:

Column A Column B
10/10/16 2
10/10/16 2
10/10/16 2
11/10/16 1

So the total for today would be 6

Thank you :-)

[zbor]

That's SUM.

Counting would be 3 as result.

Count 3, sum 6.

Solution is above.

[sunshine82]

That's great, thank you to you both :-)