appwiki:googledrive

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
appwiki:googledrive [2024/03/02 15:52] – [Google Form] yingappwiki:googledrive [2024/03/02 15:52] (current) – [Google Sheet] ying
Line 17: Line 17:
   * case: calculate sold sum of all the item with note "from showroom" <code>   * case: calculate sold sum of all the item with note "from showroom" <code>
 | A: Date | B: Status (sold/bought) | C: Name | D: Price | E: Note |</code> | A: Date | B: Status (sold/bought) | C: Name | D: Price | E: Note |</code>
-    * solution <code>=SUMIFS(D2:D, B2:B, "sold", E2:E, "from junk box")</code>+    * solution <code>=SUMIFS(D2:D, B2:B, "sold", E2:E, "from showroom")</code>
  
  
  • appwiki/googledrive.1709394742.txt.gz
  • Last modified: 2024/03/02 15:52
  • by ying