Calculate today's profit

[hsshah]

I have a stock book in which profit is calculated by a formula and dated as per the date.
I want to calculate today's profit. how can i do it.
Thanks in advance
https://picasaweb.google.com/117018858754008764470/MrExcel#slideshow/5845473510436117570

 

[Marcelo Branco]

s_zps1376d033.png Photo by hsshah | Photobucket
here is the photo with columns and row numbers
i input the following formula
=SUMIF(P3:P1048576,TODAY(),O4:O1048576)
but it didn't workout it gives nothing when i input todays date and profit

Your ranges are misaligned..

Try

=SUMIF(P:P,TODAY(),O:O)

M.