+ Reply to Thread
Results 1 to 1 of 1

Formulas

  1. #1
    Registered User
    Join Date
    02-17-2005
    Posts
    2

    Please Help Me With This Formula

    Hello everybody,

    Let’s say that I have a dropdown validation box, it contains the following list of sports cars; Ferrari, Lamborghini and Porsche. I also have another validation dropdown box, it contains a list of colours. The validation lists are repeated many times across the spreadsheet.

    At the foot of the spreadsheet is a COUNTIF formula that counts the number of times that each manufacturer appears, which is fine for Lamborghini and Porsche, but I also want to know the colour of the Ferraris.

    I need a formula in cell A3 that says, when cell A1 = Ferrari, look at cell A2 and display the colour, in addition, I also the colours to be totalled. For example, cell A4 uses my COUNTIF formula then cell B4 says, Red = 10, Blue = 5 and Black 1.

    Does that sound sensible, or am I going about this completely the wrong way? Also, can I specify that only text in uppercase can be used across the workbook?

    Thanks for your help, Kenny.
    Last edited by k9nny; 02-18-2005 at 05:19 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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