# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Id like my if statement output to be the data from a column in the table
Solved by A. Q. in 32 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 02/09/2017 - 04:09
no
Excelchat Expert 02/09/2017 - 04:10
Hi, Thank you for using Got It Pro. I’m happy to be able to help you today.
User 02/09/2017 - 04:10
awesome ank you
Excelchat Expert 02/09/2017 - 04:10
Can you illustrate a bit further
Excelchat Expert 02/09/2017 - 04:10
or type in some dummy data for me to work with
User 02/09/2017 - 04:11
i have this statment and i want the first resonse to be the total
User 02/09/2017 - 04:12
so if its billed and not paid i want it to printthe total in outstanding
Excelchat Expert 02/09/2017 - 04:12
ok does it have to be an if statement
Excelchat Expert 02/09/2017 - 04:12
there is a formula called sumifs
User 02/09/2017 - 04:13
oh how would that work?
Excelchat Expert 02/09/2017 - 04:13
Excelchat Expert 02/09/2017 - 04:13
I typed the formula in it
Excelchat Expert 02/09/2017 - 04:13
here is what it does
Excelchat Expert 02/09/2017 - 04:13
you give it a range to sum
Excelchat Expert 02/09/2017 - 04:14
if certain criteria are met in the corresponding cells
Excelchat Expert 02/09/2017 - 04:14
so the first range is the first criteria
Excelchat Expert 02/09/2017 - 04:14
is it billed
Excelchat Expert 02/09/2017 - 04:14
if yes
Excelchat Expert 02/09/2017 - 04:14
then it checks the second criteria
Excelchat Expert 02/09/2017 - 04:14
is it paid?
Excelchat Expert 02/09/2017 - 04:14
if no then it sums the value in column I
Excelchat Expert 02/09/2017 - 04:15
so try it by typing y in front of any value in column j
User 02/09/2017 - 04:16
ok
Excelchat Expert 02/09/2017 - 04:16
you can also change the paid status and it will be excluded from the calculation
User 02/09/2017 - 04:16
perfect
User 02/09/2017 - 04:16
i acn copy and paste that formula and it will work?
Excelchat Expert 02/09/2017 - 04:16
give it a try
User 02/09/2017 - 04:17
ill have to get more familar with Sumif
Excelchat Expert 02/09/2017 - 04:17
there are two formulas
Excelchat Expert 02/09/2017 - 04:17
sumif & sumifs
Excelchat Expert 02/09/2017 - 04:17
sumif for 1 criteria
Excelchat Expert 02/09/2017 - 04:17
sumifs for multiple criterias
User 02/09/2017 - 04:18
oh ok
Excelchat Expert 02/09/2017 - 04:18
Entering Discussion Phase
Excelchat Expert 02/09/2017 - 04:18
in this case I used sumifs
User 02/09/2017 - 04:18
Its printing the same number for all the data
User 02/09/2017 - 04:18
here
Excelchat Expert 02/09/2017 - 04:18
because there are two criteria to be met
Excelchat Expert 02/09/2017 - 04:18
meaning?
User 02/09/2017 - 04:19
under outstanding is "930" all the way down
Excelchat Expert 02/09/2017 - 04:19
I don't know what the outstanding does
Excelchat Expert 02/09/2017 - 04:19
but yes it is for the whole range
Excelchat Expert 02/09/2017 - 04:19
if you want to just sum to the range you are at
User 02/09/2017 - 04:19
it jusy means the total isnt paid
Excelchat Expert 02/09/2017 - 04:20
User 02/09/2017 - 04:20
i just want the data point for "total" to be displayed under outstanding if those critera are Y and N
Excelchat Expert 02/09/2017 - 04:21
ok so not cumulative
Excelchat Expert 02/09/2017 - 04:21
?
User 02/09/2017 - 04:21
no i have a total bar at the bottom
Excelchat Expert 02/09/2017 - 04:21
ok
User 02/09/2017 - 04:22
yes like that
Excelchat Expert 02/09/2017 - 04:22
User 02/09/2017 - 04:22
yes
User 02/09/2017 - 04:24
I tried putting I:I as the first argument and it just printed it
User 02/09/2017 - 04:24
ohhhhhhh no quotes
Excelchat Expert 02/09/2017 - 04:25
yes
User 02/09/2017 - 04:26
mine isnt applying to the whole column L for some reason
User 02/09/2017 - 04:26
I should have uploaded the fike
Excelchat Expert 02/09/2017 - 04:26
u still can
Excelchat Expert 02/09/2017 - 04:28
use the paper clip icon
User 02/09/2017 - 04:29
that work?
Excelchat Expert 02/09/2017 - 04:29
no
Excelchat Expert 02/09/2017 - 04:30
User 02/09/2017 - 04:31
Idk its not working. It just has a red 1 next to it
User 02/09/2017 - 04:31
can i share from OneDrive?
Excelchat Expert 02/09/2017 - 04:32
yes
Excelchat Expert 02/09/2017 - 04:33
User 02/09/2017 - 04:34
https://1drv.ms/x/s!AjE8pgdmM7qOiVcOaGQkhF_mYeQ8
User 02/09/2017 - 04:35
does that work?
Excelchat Expert 02/09/2017 - 04:35
got it
Excelchat Expert 02/09/2017 - 04:35
working on it
Excelchat Expert 02/09/2017 - 04:37
it's working
Excelchat Expert 02/09/2017 - 04:37
User 02/09/2017 - 04:37
how did you do that?
Excelchat Expert 02/09/2017 - 04:37
I just copied the formula down
User 02/09/2017 - 04:38
Excelchat Expert 02/09/2017 - 04:38
:)
Excelchat Expert 02/09/2017 - 04:38
Good job
Excelchat Expert 02/09/2017 - 04:39
Here's to many more to come
User 02/09/2017 - 04:40
Thanks for your help, If/when i come back to this site will i be matched up with you or random?
Excelchat Expert 02/09/2017 - 04:40
random
User 02/09/2017 - 04:40
wow
User 02/09/2017 - 04:40
wow
User 02/09/2017 - 04:40
well i give you a good review
Excelchat Expert 02/09/2017 - 04:41
Thank you :)
Excelchat Expert 02/09/2017 - 04:41
When you are done with the session please click on end session. Have a great day ahead :)
User 02/09/2017 - 04:41
you too

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.