Total Per Day

[SenorPantalones]

This is most likely a total newb question that someone can answer very easily, so many thanks in advance. I've tried searching to no avail. I need a formula to calculate $ amount per day using the format of the spreadsheet in the attached picture (e.g. the red box). PerDay.JPG
Thanks again!

[Bob Phillips]

If you put the dates in all rows of column A, it is a simple sumif

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

[TMS]

Don't hold your breath. Unless you're using Conditional Formatting in that Table to hide repeated dates, it won't be easy.

If you are using CF in the Table and the dates are present on each row, then you could use SUMIFS.

Not much anyone can deduce from a picture of a spreadsheet, I'm afraid.


Regards, TMS

[SenorPantalones]

Thanks guys. I'll study up on SUMIFS and start putting the date in every row. I thought it looked less cluttered without it but for functionality I'm sure its much better with it in every row. Thanks again!

[TMS]

See the example attached.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.