Use COUNTIF and SUMIF to Identify and Total Past Due Invoice Amounts in Excel

[neetuchauhan7]

Hi Danny,

Your videos are quite useful to me n to many others. Just wanna to ask is it possible to calculate YTD (year till date) with the use of sumifs formula.If yes, please help

Thanks!!

[DannyRocksExcels]

@neetuchauhan7

Thank you. I am pleased that you find my videos helpful.

Here is how you can use SUIMIF() to give you a total of Cumulative Sales up through the current date:

1) I like to used "Named Cell Ranges" in my formula. So, I name Column A "Date" and Column B "Sales.

2) In my formula, refer to the current date using the TODAY() Function

3) =SUMIF(Date, ",="&TODAY*(), Sales)

Note the use of "<=" - the quotation marks and also &TODAY() - ampersand.

Danny Rocks

The Company Rocks

[DannyRocksExcels]

@neetuchauhan7

I just posted a YouTube Video lesson to address your question:

The title is "Use SumIf in Excel to Total Year to Date Sales."

Best,

Danny Rocks

The Company Rocks

[neetuchauhan7]

Thanks danny:)

[neetuchauhan7]

Hi Danny,

Is it possible to make YTD formula dynamic with the use of sumifs formula.If yes, Please suggest.

Thanks

[LoniHart]

Using the "now" or" today" i a paragraph with several other funtions that are none date (currency) the format gets buggered improperly Is there a way to format each formula in one cell, (date, currency, text)?

[LoniHart]

Thanks for sharing on how to use count if in excel. I cannot get it to count the following properties with ocean view. If I put count if a2a12,Ocean it only yields one? and work around? OCEAN

Ocean View,Water View

Marina View,Ocean View,Panoramic View,Water View

Canyon View,Hills View

Coastline View,Hills View,Ocean View,Panoramic View,View,Water View,White Water View

Catalina Island View,Ocean View,Water View,White Water View

Coastline View,Ocean View,Water View

[peeweecee]

Excellent video! I learned so much in a short period of time.  Your pace really is perfect. Thank you.

[DannyRocksExcels]

@peeweecee

Thank you for writing to tell me that you enjoyed my video.

Over the years, I have learned how to "pace" my teaching style so that most people can follow the concept. I appreciate you bringing this to my attention.

Sincerely,

Danny Rocks

The Company Rocks

[radovandr]

outstanding!!!!!

[DannyRocksExcels]

@radovandr

Thank you for your comment - I am pleased that you found this video helpful.

Danny Rocks

[friedwanton]

Thanks Danny.. You Rock!!!!!

I am able to use this now..

[DannyRocksExcels]

@friedwanton

Thanks - that make me very happy. I am pleased that I could help you.

Danny Rocks