Results 1 to 7 of 7

Excel 2007 : Need to sum if the numbers are multiples of 2 or 3

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-28-2011
    Location
    Delhi
    MS-Off Ver
    Excel 2007
    Posts
    101

    Need to sum if the numbers are multiples of 2 or 3

    List of numbers, e.g,

    1 2 3 4 5 6 7 8 9 10 11 12 13 14 etc. in (say) Column A.

    Need to sum the numbers which are multiple of 2 and 3 [Catch is that the number multiple of both 2 and 3 need to be picked up only once, for example 6].

    Thanks
    Last edited by sushil10s; 02-14-2012 at 01:11 PM.

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