+ Reply to Thread
Results 1 to 8 of 8

Update a formula for Access 2010

Hybrid View

  1. 08-10-2015, 07:44 AM #1
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Update a formula for Access 2010

    Unless I'm very much mistaken, COUNTIFS will work perfectly well with whole column references (which SUMPRODUCT definitley does not like).
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  2. 08-10-2015, 07:50 AM #2
    Tina G
    Tina G is offline
    Registered User
    Join Date
    05-07-2014
    Location
    Norfolk
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Update a formula for Access 2010

    Hi Glen and John

    Thank you for your replies - the COUNTIFS works and is content with whole column references too.

    Thank you very much.

    Tina
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2010, Access 2010, SQL Insert and Update Statments and NULL value in Field
    By jmmach72 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2013, 02:35 PM
  2. Using DAO to pull data from Access 2010 into an Excel 2010 table
    By Ragnaros in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-23-2013, 01:28 PM
  3. Excel 2010 userform to access and edit the data in MS ACCESS DB tables
    By anand_y59 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2012, 07:46 AM
  4. excel 2010 vba to save access 2010 database and close it
    By dearnemo385 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-17-2012, 11:56 AM
  5. Update/Delete a Record in an Access 2010 Database using Excel VBA
    By tomlancaster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2012, 12:36 PM
  6. Dynamic Chart Title in 2010 without access to formula bar
    By foxgoku in forum Excel General
    Replies: 15
    Last Post: 01-25-2012, 02:05 PM
  7. Update excel OLE unbound object withing Access 2010
    By Snoopy2003 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-23-2011, 03:17 AM
  8. Update excel OLE unbound object withing Access 2010
    By Snoopy2003 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-22-2011, 07:26 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1