# 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.  Register To Reply

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   Register To Reply

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.  Register To Reply

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))  Register To Reply

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)  Register To Reply

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?  Register To Reply

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

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

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

I understand, thank you!  Register To Reply