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.
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
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry, here is the attached. I'm trying to convert this simple formula to a Google Sheet.
Thanks.
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))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
you could also use the FILTER function
=iferror(SUM(filter($A$1:$A$10,$B$1:$B$10=E3,$C$1:$C$10="")),0)
Josie
if at first you don't succeed try doing it the way your wife told you to
Hi Guys, I appreciate the help. I tried copying both your code to G3, and both returned sums of 0. Any ideas?
that's what they should return for the data you have-nothing matches all the criteria :-)
I understand, thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks