• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to use SUMIFS formula where the 2nd criteria is in a single cell?

R

RadMan

New Member
Hello,

I've searched the forum for examples of SUMIFS formulas. There's a lot on adding the total for a column when the criteria for two columns meet. But I'm trying to add a column when one criteria is in an adjacent column and the other is in a single cell on the same spreadsheet. Any suggestions?


=SUMIFS(D3:D340,F3:F340,"American Funds",J20,"1")----this doesn't work
 
How about:

Code: 
=IF(J20=1,SUMIFS(D3:D340,F3:F340,"American Funds"),"")
 
You must log in or register to reply here.
Back
Top