+ Reply to Thread
Results 1 to 2 of 2

SUMIFS formula with Cell reference

Hybrid View

  1. #1
    Registered User
    Join Date
    08-09-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    10

    SUMIFS formula with Cell reference

    Hi,

    In SUMIFS formula instead of giving particular value i want to give cell reference from diffrent sheets. how do i do it..

    For Eg: =SUMIFS(A1:A20, B1:B20, ">0", C1:C20, "<10") instead of like this i want to give as below

    =SUMIFS(A1:A20, B1:B20, "E30", C1:C20, "G10") where E30 and G10 are the cell references.

  2. #2
    Forum Contributor
    Join Date
    10-02-2012
    Location
    Bumi Nusantara
    MS-Off Ver
    Excel 2010; Excel 2016
    Posts
    136

    Re: SUMIFS formula with Cell reference

    try this code
    =SumProduct((B1:B20=E30)*(C1:C20=G10)*A1:A20)
    click the star if it solves your problem

+ Reply to Thread

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