Hi all I have a SUMIF that is working almost great... I need it to know whether or not it is a positive number or negative by using a C40 (C40 has a drop down of ADD, Blank and Remove).
any help would be greatly appreciated!
=SUMIF($J$39:$W$39,"Extended Price",J41:W41)
Thank you!
Alex
Don't understand the C40 part of your post could you explain a little better maybe post an example with what you are trying to do.
Yes it will. we just have to figure out how...
If I have helped you, PLEASE click the * and add to my Rep.
Also, if the problem is SOLVED please mark it as so.
the problem with your post is we have NO idea of what you expect to see for what condition...
I suggest uploading a sample sheet, with a few answers worked out, to show us what YOU expect to see when its done
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Sorry about that all, please see attached. I am try to use column C to determine whether or not the "total Driver" is a positive number or negative value. ("Add" and leaving the cell "blank" is positive number and "remove" is a negative number)
Thank again
example sumif.xls
does this better explain what I am trying to do?
See below for the most up to date formulas I have
example sumif corrected.xls
Well, it's nice to see a layout....but I see no expected results, or any clue of where the working data is??
What are we expected to apply the formulas to? and where is the C40 reference?
I'm not trying to be difficult, I just see NOTHING to work with...
Check this file I think it answers your question.
Thank you
example sumif corrected REV2.xls
maybe this one???
Formula:
Please Login or Register to view this content.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
see if this is getting you closer to desired result :
in G2 dragged down:
Formula:Please Login or Register to view this content.
Also, why have you got Columns G & H merged? no need for it, and it will bee a pain eventually...
Hope this helps
Edit-
Should return a 0 if column c= "blank"
Last edited by dredwolf; 02-17-2013 at 09:46 PM.
That was it! Thank you for your help!
Alex
Must be vlady's your talking about, you posted seconds after me...lol
Yeah she got me there, but without your coaching no one would have ever known what I was trying to do! Thanks for the help!
Alex
No Problem!, Just glad we got you an answer that works!
Please remember to mark the thread as solved if you are satisfied with your solution :
To mark thread "Solved", go to the top of the thread,click "Thread Tools",click "Mark as Solved"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks