Results 1 to 3 of 3

sumifs or sumproduct

Threaded View

goodboy sumifs or sumproduct 04-10-2013, 09:43 AM
benishiryo Re: sumifs or sumproduct 04-10-2013, 09:48 AM
rcm Re: sumifs or sumproduct 04-10-2013, 09:53 AM
  1. #1
    Forum Contributor
    Join Date
    08-22-2010
    Location
    mumbai
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    186

    sumifs or sumproduct

    kindly refer the attached sheet. I want to look for the value mentioned against the date and add the same for both the columns and mention in column H. eg g1 is 1-Apr-13 so the value of B1 and E30 ie 1+1=2 should be in cell H2.
    I know of sumifs or sumproduct will get me what I want but I tried with no result kindly help.

    Thanks
    Attached Files Attached Files

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