Results 1 to 14 of 14

Google Sheets: If cell has any value, print this...

Threaded View

  1. 08-22-2021, 01:15 AM #1
    Jetheat
    Jetheat is offline
    Registered User
    Join Date
    05-30-2004
    Posts
    63

    Google Sheets: If cell has any value, print this...

    How would I write a formula for:

    If cell G3 has any value in it, while H3 remains empty, then print the sum of all the previous values of column F.
    However, if cell H3 also has a value in it, then print the sum of all the previous values of column E.

    How would I write this formula is cell I3 ?

    Thanks,
    (See attachment)

    JH
    Attached Images Attached Images
    Using Excel for Mac
    But mostly use Google Sheets
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Google sheets - change cell color based on days past date in another cell
    By Coffey80 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 03-10-2021, 03:20 PM
  2. Google Sheets: Condition formatting in Google sheet
    By cyee in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 02-18-2021, 05:35 PM
  3. [SOLVED] Google sheets script to download file and save it to google drive folder and use it's data
    By western in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 01-18-2021, 01:31 PM
  4. [SOLVED] Google sheets vba to download file and save it to google drive folder and use it's data
    By western in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2021, 08:48 AM
  5. [SOLVED] Google sheets: Function to return a value from another tab/cell
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-27-2019, 02:04 PM
  6. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  7. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1