Results 1 to 3 of 3

Sumifs with criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-30-2011
    Location
    wirral,england
    MS-Off Ver
    Excel 2010
    Posts
    148

    Sumifs with criteria

    Hello all
    On the attached worksheet i wish to count the data in col x using the criteria in cols A to E,then divide by the value in col AJ.Can the formula i am using be modified to return a blank cell in the result col AT,when the value in AJ is blank.(its now returning #DIV).Can the result also be given to 1 dec place.What im trying to achieve is shown in col AW

    Formula is SUMIFS(X:X,A:A,A2,D:D,D2,E:E,E2)/AJ2

    Many thanks for help given
    Attached Files Attached Files
    Last edited by bigband1; 02-04-2014 at 04:25 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 11-21-2012, 04:57 PM
  2. [SOLVED] Sumifs Criteria
    By shakra in forum Excel General
    Replies: 5
    Last Post: 07-24-2012, 02:12 AM
  3. Replies: 5
    Last Post: 09-07-2011, 11:14 PM
  4. Replies: 1
    Last Post: 05-16-2011, 05:00 PM
  5. sumifs criteria
    By Wrighty in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-22-2010, 07:14 AM

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