Sumif help

[masond3]

Hey guys

I Need some help with a formula.

I am trying to write a formula, which
looks at the stage “column f” if stage = “Application Docs Out”, sum column V, but only sum column V if the stage = “Application Docs Out”, is greater than 13

I have written a formula were i have summed stage and TCV and the formula is as follows “=SUMIFS(TCV,Stage,AG5)” , I just don’t know how to get the greater than 13 to be included.

Also i have named my columns

Column F = Stage
Column V= TCV
AG5= Application Docs Out


Looking forward to your help and advice

[Fotis1991]

Hi

Maybe.

=sumifs(tcv,stage,“Application Docs Out”, Application Docs Out;">13")

[masond3]

hi Fotis1991, that doesnt seem to work, any other ideas ?

[Fotis1991]

My best idea is to upload a small sample workbook.

[Peter.M]

Fotis' formula has a semi-colon instead of a comma. Fix that and it should work

[Fotis1991]

Thanks Peter. We use in Greece seni-colons and not comma for the formulae.

So every time, i have to change semi-colons to comma. Many times, i don't do this..very well..I forget at least one...

[masond3]

Please find attached worksheet.

Can someone apply this formula, to this work sheet and re upload ?

[Fotis1991]

=SUMIFS(TCV,Stage,$AG$5,TCV,">13")

Result is 19225.

[masond3]

hi fotis thank you for your help . thats still not right though, i have dropped you a pm.

[Fotis1991]

....hi fotis thank you for your help . thats still not right though, i have dropped you a pm.

I strongly believe that formula is correct.

I did this with 170 rows to be easy to test it. Result is correct. See the example.

I saw your pm. I have no reason to don't give to you my email, but i believe that is not necessary.

For you is better here, because you will find your solution from many people

[jason.b75]

thats still not right though

That doesn't tell us much, try posting the result you expect from the formula based on the sheet you attached to post #7 so we have a known value to compare to.

[Pepe Le Mokko]

I haven't checked the entire thread but shouldn't the last condition ( >13) apply to column W instad of column V ?

Please Login or Register  to view this content.

(returns 1158 on that range)

[masond3]

Okay

Apply filter across the top,
Go to column F, and only select stage “Application Docs out”
You should have 105 records come up

Check columns i, j and K, These columns should all be blank
( i know there is data in row 1031 as there is a date stamp within that column, so please remove this )

you should now have 104 records

Go to column V and give me a total of how much “Application Docs out” is worth . in this instance 18930

however i need column h date to be worked out from 6 weeks from today’s date preferably in networking days

[masond3]

Please ingore first post the criteria as now changed. Please base formula on the last post

[Fotis1991]

....Please ingore first post the criteria as now changed. Please base formula on the last post

OK. I'LL do it but first i'd like to understand that 1) i spend much time on this and 2)

...Apply filter across the top,
Go to column F, and only select stage “Application Docs out”
You should have 105 records come up

Check columns i, j and K, These columns should all be blank
( i know there is data in row 1031 as there is a date stamp within that column, so please remove this )

you should now have 104 records

Go to column V and give me a total of how much “Application Docs out” is worth . in this instance 18930

I did it and here is the result..! Isn't it?

[masond3]

Hi The first post is still correct, but if i get the6 week posting working, i know that that the 13days is less important as the 6 week takes privillage

And no the formula is incorrect; i Don’t want to manually keep filtering the sheet. I need the formula to work regardless of how many pieces of data there is

[Fotis1991]

...And no the formula is incorrect;

Formula is CORRECT and result too! I prooved it!! No need to do manually Nothing...

And as i worked on this, ..here is a solution for your new requietment..

[masond3]

Fotis1991 i owe you so much. Next time i am in greece i will need to visit you, and repay the faith. You are a star

[Fotis1991]

You are welcome! Waiting for you in Greece!

Would you pls, mark your thread, as solved?