The result is nine because we have this first row here is A0012 and it's a 4. We'll say when it's TRUE we'll going to take the values in Column B. I'll put quotes around this and that will return TRUE in two cases here cases here, two rows. So I'll put a formula here, SUMIF, and then we'll take column A here, so product sales A, and what we'll do is we'll compare that to A0012. Say we want to get the total for a certain product or group of products. We've got products with names like A0012, A0016, etc. For instance, say here we've a table with product sales. Wildcards allow you to compare strings but specify that you don't care what a particular character or group of characters is. Video Transcript: So let's take a look at using wildcards in Numbers. Check out Using Wildcards In Numbers Formulas at YouTube for closed captioning and more options.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |