• 409K Members
• 11.3K Online
• 466K Conversations
SOLVED

## Sumif or Sumifs help

Occasional Contributor

# Sumif or Sumifs help

I want to count and add the value in cell B:B if cell A:A is red and D:D is today

 red 25 8/9/2019 blue 27 red 65 9/9/2019 total red 90 8/9/2019 25 blue 27 8/9/2010 0

8 Replies
Solution

# Re: If or count if help

=SUMIF(A:A,"red",B:B) sums all cells in column B where column A equals "red".

# Re: If or count if help

=SUMIFS(B1:B3,A1:A3,"red") should work for you.

# Re: If or count if help

Thank you, it say array are different size.

# Re: If or count if help

Thank you it say array are different size.

# Re: If or count if help

All arguments in the function must point to the same number of rows.

# Re: If or count if help

@Jan Karel Pieterse yey, i got it. Thank you so much

# Re: If or count if help

what if i want to add another condition if cell C:C is equal to green?

# Re: If or count if help

That would mean adding the condition to the formula:
=SUMIFS(B1:B3,A1:A3,"red",C1:C3,"green")
Note that BOTH conditions must be met, if you want to sum them if either condition is met:
=SUMIFS(B1:B3,A1:A3,"red")+SUMIFS(B1:B3,C1:C3,"green")
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies