SOLVED

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
Highlighted
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
Highlighted
Solution
=SUMIF(A:A,"red",B:B) sums all cells in column B where column A equals "red".
Highlighted

@iceice 

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

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

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

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