**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.*