Thread: Sum of sum criteria Thanks: 0 Likes: 0

1. Sum of sum criteria

Hi all,

Sure this is simple for an expert.

Below is the formula to return the value of A3 if the values in row C add to zero.

=(IF(SUM(C3:F3)=0,A3,0))

How do I sum the total of all of all the values from A3:A15 that meet the criteria using relative cell references for column C criteria?

Thanks!  Reply With Quote

2. Re: Sum of sum criteria

Just to clarify, I can get the answer with:

=SUMIFS(A3:A15,C3:C15,0,D3:D15,0,E3:E15,0,F3:F15,0)

But is there a more elegant formula, for example if there were 50 criteria columns rather than 4?

Thanks.  Reply With Quote

3. Re: Sum of sum criteria

You could put
=SUM(C3:F3)
in another column, drag down & then use
=SUMIF(G3:G15,0,A3:A15)  Reply With Quote

4. Re: Sum of sum criteria

Hi,

without Helper-Column

=SUMPRODUCT(A3:A15,--(MMULT(--(C3:F15=0),TRANSPOSE(COLUMN(C:F)^0))=COLUMNS(C:F))) Greetings

Christian  Reply With Quote

User Tag List

Tags for this Thread

=ifsumc3f3=0, criteria, simple, sum, values  Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•