Results 1 to 7 of 7

Forumula Help

Threaded View

  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    UK
    Posts
    14

    Forumula Help

    Hi

    Can anyone help with a formula to do the following.

    1) If nothing is entered in split (B11) it show the total spend for customer 529908 but if you enter in B11 CCTV it would only calculate customer 529908 and it would should £300 but if you entered Access it would only show 50.

    Thanks
    Roy
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Forumula If Else Help
    By chungiemo in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-16-2017, 09:10 AM
  2. Help with forumula
    By iain2ks in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-13-2017, 09:05 AM
  3. [SOLVED] Help with forumula (if possible)
    By dreds42 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-10-2015, 11:24 AM
  4. Replies: 6
    Last Post: 03-12-2014, 12:16 PM
  5. Forumula for MAX
    By SAFCliam in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-24-2013, 10:53 AM
  6. need help with a forumula
    By Robtastic in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-20-2012, 05:11 AM
  7. Help with FORUMULA
    By LoriM in forum Excel General
    Replies: 0
    Last Post: 01-07-2005, 04:06 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