![]() ![]() If you run out of space in the table, just do the same thing you did earlier for the main table by inserting the cells above the last line in the table. For this, I use Google’s SUMIFS function because it sums a range depending on specified criteria (such as, checking that adjacent B cell matches the corresponding E cell). I am checking the amounts in the whole table (C21:C62), and am summing them only if their corresponding store name value in the table (B21:B62) is the same value as the corresponding store name in the associated calc (E28). Finally, the CONCATENATE function simply combines, or concatenates, the two text values of "September" (from TEXT(EDATE.)) and " Rent".Ĭolumn B accepts user input, except for B7 which comes from a separate table that I’ll cover later on.Ĭolumns D and E split the corresponding value in Column B based on provided percent values in the second table we’ll go over, the splits table. In this case, the format provided is "MMMM" which is the string month formatting ( "MM" would convert it to "09" instead of "September"). ![]() TEXT() converts a specific number into text depending on provided format. The EDATE() function projects a given date before/after a specific number of months. ![]() I get the current month from today’s date using TODAY(). I find the current date’s month, add one to it, convert it to a string, and then concatenate it with “Rent”. The month updates automatically with the current date. Not the end of the world, but it doesn’t hurt to have a little reminder. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |