Numbers formula help

[twerppoet]

That's an interesting solutions. Thanks for sharing it.

Here is a quick tip, if you have not discovered it for yourself:

To quickly enter the current date in to a cell, try this. Instead of entering each item (month, day, year) in order immediately select day. A Today button will appear on the keypad. Tap it an the other two values will be entered as well.

Makes date entry (almost) bearable.

[Ads]

[Abunaixd]

Wow never knew about that trick, thank you for sharing that twerppoet.

[twerppoet]

No problem. I stumbled onto it when I had to enter a large number of dates to test a spreadsheet.

You can do the same thing with the time using NOW after selecting the hour. Of course that is less useful, but there.

[Mkupslik23]

Can someone please tell me how to navigate to SUMIF ??

[twerppoet]

You tap the Function key when in formula editor mode. On the menu that pops up choose the Categories tab, then either All or Numeric category. Swipe to scroll down until you see the SUMIF function. Tap it to select, or tap the blue arrow to the right of it for a description and examples.

Once you've selected and used it should show up in the Recent tab.

[Mkupslik23]

Thank you sooo much : ) Still learning my way around....had a blonde moment!

[twerppoet]

Not a problem.