Comments on: How To Use the SUMIF Google Sheets Function (3 Easy Examples)

By: Ziad G.

Ziad G. — Fri, 24 Mar 2023 10:25:02 +0000

Hello Everyone!

Can you please help with his formula! It works perfectly but I need to make it an array formula,

=(SUMIFS(‘In-Out Official’!$H:$H,’In-Out Official’!$I:$I,”LBP”,’In-Out Official’!$E:$E,””,’In-Out Official’!$B:$B,$A:$A))

Many thanks 😀

By: Christopher Daniel

Christopher Daniel — Tue, 13 Dec 2022 00:28:45 +0000

In reply to Anna. Thanks, Anna. You're right

By: Anna

Anna — Sat, 26 Nov 2022 22:06:38 +0000

Under title “Can the SUMIF Function Be Case Sensitive?” the formula has redundant brackets. Instead of
=SUMIF(ARRAYFORMULA((FIND(“Product c”;A2:A6));1;B2:B6) should be
=SUMIF(ARRAYFORMULA(FIND(“Product c”;A2:A6);1;B2:B6)

By: Anna

Anna — Thu, 24 Nov 2022 08:05:49 +0000

The trick under title “How Do I SUMIF Multiple Columns In Google Sheets?” doesn’t work for me. I have found the solution which works and does the same:
=sum(SUMIF(D2:D6;”John”;B2:B6);SUMIF(D2:D6;”John”;C2:C6))

By: Kris

Kris — Tue, 08 Mar 2022 23:09:17 +0000

If I have several columns that when added across equal less than 250.00 how do I set the sum total to be 250.00. If it goes over 250.00 I would just need the sums added across the columns.

By: Thieme

Thieme — Wed, 26 Jan 2022 14:32:30 +0000

Just a comment, I repeated got a parsing error, finally I found out that the solution was quite simple: replacing the comma with a ; did the trick. So somehow Sheets doesn’t work (anymore?) with commas?

By: Jose Luis

Jose Luis — Thu, 08 Jul 2021 22:45:21 +0000

Hi,

This is super super helpful, how do I sum the contents for a week range, for example, give me the total units for the week of Monday July 19 to Friday July 23?

Thank you for your help!

By: Sudeep S

Sudeep S — Tue, 18 May 2021 21:51:13 +0000

Thank you so very much! This worked like a charm. Saved me hours of racking my brains to figure out what to do.