Results 1 to 14 of 14

Ifvlookup - Average for - 2 criteria (For Google sheet)

Threaded View

  1. 07-04-2022, 11:07 PM #1
    Asdf99
    Asdf99 is offline
    Registered User
    Join Date
    06-16-2022
    Location
    bali
    MS-Off Ver
    Google Sheet
    Posts
    41

    Smile Ifvlookup - Average for - 2 criteria (For Google sheet)

    Hi guys,

    I hope you all have a good day

    I was wondering if you can help me create a formula for Average for 2 set of criteria.

    So in my excel you can see I need the formula to be in column E & F. But I need you guys to not include (ignore) table A19:D25 and (ignore) table H2:I14 to the formula since it's just to show for an understanding.


    thank You
    Attached Files Attached Files
    Last edited by Asdf99; 07-05-2022 at 07:23 AM.
    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. [SOLVED] how to use sumproduct subtotal with criteria in another sheet. on google sheet
    By sandiwa02 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 02-04-2022, 07:38 AM
  2. Google Sheet (Subtract the two cell value using multiple criteria)
    By imgiboy27 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-15-2021, 09:40 PM
  3. Google Sheet (Subtract the two cell value using multiple criteria)
    By imgiboy27 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-11-2021, 11:16 PM
  4. [SOLVED] Google Sheets: If 2 criteria are met, display value from next column on other sheet
    By Gavin101 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 13
    Last Post: 08-04-2021, 05:13 PM
  5. Google sheet: Help to attachment file from Google Drive and send email fill in Google Form
    By sbv1986 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 03-01-2021, 10:47 PM
  6. Average n top values with data chosen by mutliple criteria - Google sheets
    By david.gnaniah in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-28-2020, 07:53 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