SOLVED
Home

Sumif or Sumifs help

%3CLINGO-SUB%20id%3D%22lingo-sub-784088%22%20slang%3D%22en-US%22%3ERe%3A%20If%20or%20count%20if%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-784088%22%20slang%3D%22en-US%22%3E%3DSUMIF(A%3AA%2C%22red%22%2CB%3AB)%20sums%20all%20cells%20in%20column%20B%20where%20column%20A%20equals%20%22red%22.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-784098%22%20slang%3D%22en-US%22%3ERe%3A%20If%20or%20count%20if%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-784098%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385797%22%20target%3D%22_blank%22%3E%40iceice%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DSUMIFS(B1%3AB3%2CA1%3AA3%2C%22red%22)%20should%20work%20for%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-784106%22%20slang%3D%22en-US%22%3ERe%3A%20If%20or%20count%20if%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-784106%22%20slang%3D%22en-US%22%3EThank%20you%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-784143%22%20slang%3D%22en-US%22%3ERe%3A%20If%20or%20count%20if%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-784143%22%20slang%3D%22en-US%22%3EThank%20you%2C%20it%20say%20array%20are%20different%20size.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-784147%22%20slang%3D%22en-US%22%3ERe%3A%20If%20or%20count%20if%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-784147%22%20slang%3D%22en-US%22%3EThank%20you%20%3A)it%20say%20array%20are%20different%20size.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-784161%22%20slang%3D%22en-US%22%3ERe%3A%20If%20or%20count%20if%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-784161%22%20slang%3D%22en-US%22%3EAll%20arguments%20in%20the%20function%20must%20point%20to%20the%20same%20number%20of%20rows.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-784166%22%20slang%3D%22en-US%22%3ERe%3A%20If%20or%20count%20if%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-784166%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3Byey%2C%20i%20got%20it.%20Thank%20you%20so%20much%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-784172%22%20slang%3D%22en-US%22%3ERe%3A%20If%20or%20count%20if%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-784172%22%20slang%3D%22en-US%22%3Ewhat%20if%20i%20want%20to%20add%20another%20condition%20if%20cell%20C%3AC%20is%20equal%20to%20green%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-784058%22%20slang%3D%22en-US%22%3ESumif%20or%20Sumifs%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-784058%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20count%20and%20add%20the%20value%20in%20cell%20B%3AB%20if%20cell%20A%3AA%20is%20red%20and%20D%3AD%20is%20today%3C%2FP%3E%3CTABLE%20border%3D%221%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3Ered%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E8%2F9%2F2019%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3Eblue%3C%2FTD%3E%3CTD%3E27%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3Ered%3C%2FTD%3E%3CTD%3E65%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E9%2F9%2F2019%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3Etotal%3C%2FTD%3E%3CTD%3Ered%3C%2FTD%3E%3CTD%3E%3CP%3E90%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E8%2F9%2F2019%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E25%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3Eblue%3C%2FTD%3E%3CTD%3E%3CP%3E27%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E8%2F9%2F2010%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E0%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-784058%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787727%22%20slang%3D%22en-US%22%3ERe%3A%20If%20or%20count%20if%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787727%22%20slang%3D%22en-US%22%3EThat%20would%20mean%20adding%20the%20condition%20to%20the%20formula%3A%3CBR%20%2F%3E%3DSUMIFS(B1%3AB3%2CA1%3AA3%2C%22red%22%2CC1%3AC3%2C%22green%22)%3CBR%20%2F%3ENote%20that%20BOTH%20conditions%20must%20be%20met%2C%20if%20you%20want%20to%20sum%20them%20if%20either%20condition%20is%20met%3A%3CBR%20%2F%3E%3DSUMIFS(B1%3AB3%2CA1%3AA3%2C%22red%22)%2BSUMIFS(B1%3AB3%2CC1%3AC3%2C%22green%22)%3C%2FLINGO-BODY%3E
iceice
Occasional Contributor

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

red25 8/9/2019 
blue27   
red65 9/9/2019 
totalred

90

8/9/2019

25

 blue

27

8/9/2010

0

  

 

 

 

 

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

@iceice 

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

Thank you, it say array are different size.
Thank you it say array are different size.
All arguments in the function must point to the same number of rows.

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

what if i want to add another condition if cell C:C is equal to green?
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