+ Reply to Thread
Results 1 to 4 of 4

Simple formula help

  1. #1
    Registered User
    Join Date
    05-26-2022
    Location
    London
    MS-Off Ver
    Windows 10
    Posts
    2

    Question Simple formula help

    Hello,

    Looking help to create a formula for the below:


    If cells M13:M251 Says ‘Antonio’ and cells P13:1251 says ‘No’ then add up the figures in I13:I251

    Thank you....

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Simple formula help

    Use a pivot table to analyse the data.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    05-26-2022
    Location
    London
    MS-Off Ver
    Windows 10
    Posts
    2

    Re: Simple formula help

    I just need a formula - maybe a countifs or sumsif of some sort?

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,896

    Re: Simple formula help

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

    Administrative note
    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your XL version. It indicates your operating system version which is of no help to us.
    Thanks
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 07-24-2019, 02:04 PM
  2. Simple Formula When Input for Formula is null
    By ulala2 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-25-2017, 10:27 AM
  3. [SOLVED] Help with formula (simple)
    By Marvo in forum Excel General
    Replies: 5
    Last Post: 03-06-2015, 07:44 AM
  4. Replies: 4
    Last Post: 12-07-2012, 11:49 AM
  5. simple formula
    By Brian in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. [SOLVED] Help with 'simple' formula
    By Brian in forum Excel General
    Replies: 3
    Last Post: 07-18-2005, 02:05 PM
  7. [SOLVED] Help with a simple formula
    By PghPatti in forum Excel General
    Replies: 12
    Last Post: 02-14-2005, 12:12 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1