# Basic Sum Formula in Google Sheets

1. ## Basic Sum Formula in Google Sheets

Hi All,

I have a basic question. In the attached, you can see I have a basic 3 columns. The cells should be self-explanatory I hope. For the 3rd column, the blank cells represent "Unpaid".

I would like a formula that says:
a) The sum that John has "Unpaid"
b) The sum that Mike has "Unpaid"

Below is how it looks in Excel, but doesn't quite work in Sheets
=SUMIFS(A1:A10,B1:B10,"Mike",C1:C10,"")

=SUMIFS(A1:A10,B1:B10,"John",C1:C10,"")

Can anyone help? Thanks.

2. ## Re: Basic Sum Formula in Google Sheets

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you

3. ## Re: Basic Sum Formula in Google Sheets

Sorry, here is the attached. I'm trying to convert this simple formula to a Google Sheet.

Thanks.

4. ## Re: Basic Sum Formula in Google Sheets

Hi. Results of your formula are correct.

I don't use Google sheets but as i know you can use SUMPRODUCT on these..

In G3 and copy down..

=SUMPRODUCT((\$B\$1:\$B\$6=E3)*(\$C\$1:\$C\$6="")*(\$A\$1:\$A\$6))

5. ## Re: Basic Sum Formula in Google Sheets

you could also use the FILTER function
=iferror(SUM(filter(\$A\$1:\$A\$10,\$B\$1:\$B\$10=E3,\$C\$1:\$C\$10="")),0)

6. ## Re: Basic Sum Formula in Google Sheets

Hi Guys, I appreciate the help. I tried copying both your code to G3, and both returned sums of 0. Any ideas?

7. ## Re: Basic Sum Formula in Google Sheets

that's what they should return for the data you have-nothing matches all the criteria :-)

8. ## Re: Basic Sum Formula in Google Sheets

I understand, thank you!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1