I need some help in calculating daily profits (the last day daily profits).
In Q1 I'd like it to add the contents of column Q until the dates change.
The last day of profits is 3/22/18 and the profits are $1,635.05.
Thanks.
I need some help in calculating daily profits (the last day daily profits).
In Q1 I'd like it to add the contents of column Q until the dates change.
The last day of profits is 3/22/18 and the profits are $1,635.05.
Thanks.
So you are looking for a formula to sum the numbers in column Q that correspond to the last day of entries?
If so, try this:
=SUMIF(C6:C34,LOOKUP(2,1/(E6:E34<>""),C7:C35),Q6:Q34)
It returns 1653.05
Perfect.
My XLS is exactly how I want it.
Thanks.
You're welcome. Thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks