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
please check cell A2
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
use this instead
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
please check column L
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
upload and hit enter
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
share the link
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
please check it now
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
how hah this is my first spread sheet ive made
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.
