Results 1 to 5 of 5

IF array with COUNTIF??????

Threaded View

alfgrey IF array with COUNTIF?????? 09-05-2013, 06:23 AM
Fotis1991 Re: IF array with... 09-05-2013, 06:39 AM
alfgrey Re: IF array with... 09-05-2013, 06:57 AM
alfgrey Re: IF array with... 09-05-2013, 06:58 AM
Fotis1991 Re: IF array with... 09-05-2013, 07:10 AM
  1. #1
    Forum Contributor
    Join Date
    09-04-2013
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    122

    IF array with COUNTIF??????

    Ok, i have an overhead table in a sheet (attached), im going to use dependant dropdown lists for category & sub-category. The next field is receipt number (if applicable) The reason is we assign daily expenses (carpark ticket, fuel, train etc etc) with a receipt number 1,2,3,4 ascending as high as necessary until the next business year when we start a new BLANK workbook template. However we do not assign "overhead" items a number as these are generally Monthly or annual receipts that are just stored in an overhead folder. However i want to record both Overheads and expenses on the same sheet.

    So, what i want to achieve is for the receipt number column to automatically generate either a receipt number (which is +1 to the previous receipt number) or enter the value"Overhead folder" Ive got as far as =IF(D2="Overhead","Overhead Folder",IF(D2=Expense,SOME SORT OF COUNT FUNCTION,""))

    My logic tells me i need a function to count the number (not test for the SUM of the cells) of cells in the receipt number column which contains a number value only and return a value to the cell with +1 sort of like an auto-number feature but as im fairly new to the advanced stuff in excel im not sure how to express it.

    ReceiptNoForumHelp.xlsx
    You might of guessed, i want it to return as blank if neither are true.

    Any help greatly appreciated.
    Attached Files Attached Files
    Last edited by alfgrey; 09-05-2013 at 08:20 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Countif in an array
    By Petijandro in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2013, 07:48 AM
  2. countif substring from array
    By 2518GA in forum Excel General
    Replies: 2
    Last Post: 09-01-2010, 06:10 AM
  3. Array Countif
    By H43825 in forum Excel General
    Replies: 1
    Last Post: 05-01-2009, 12:04 PM
  4. [SOLVED] How do I use countif an array for >=45<=50
    By البيانات in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-04-2006, 04:25 PM
  5. sumproduct , array or countif?
    By cjjoo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-10-2005, 11:36 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