I'm stuck again! With all of your help I feel like I should be able to figure it out but so far I can't. This formula works:
=MEDIAN(IF(disc="y",IF(obj="equ",total,""),""))
but now I need to add one more criteria (tax="tax").
Thanks in advance for your help.
Lorraine (aka Lo)
Thanks Ken! I haven't had time to really try to understand the whole thread(68-1291533) but it looks like it contains alot of great information.
With everyone's help I have been able to make a big dent in the project that I'm working on and hopefully am beginning to better understand excel...
I have a PC with two network adpaters, and one of the programs requires that the adapter it uses is listed first. Today the order of the adapters switched. I have now lost my connection to the equipment that one of the adapters is connected to. Does anyone know how to change the order that the...
ok, I tried SUMPRODUCT, it worked and I understood it. I just tried the array and was able to get it to work but had more trouble with it. I am making a template on one worksheet with all my formulas and will be pasting data into a 2nd worksheet. I thought you used $ to make something...
I am trying to work on suggestions given to me yesterday & they are VERY much appreciated! Unfortunately, I get pulled in many directions at work, as I'm sure we all do. I will let you know if I'm successful and which way worked best for me. I will keep these examples & use them for future...
I did get responses to my question yesterday that I'm just getting ready to try. First, I needed to check one column and then sum data, so SUMIF worked great. Then I needed to check data in 2 columns and if they were both = to my criteria then sum data. I assumed that I would still use SUMIF...
Thanks, I did spend quite a bit of time yesterday playing with my "sumif" question before emailing the group. Although I did not break excel, I think it started to break my spirit. I know I can automate so many of my tasks here at work if I can learn to use excel formulas better. I'll keep...
Last Friday I took a level 2 excel class that supposedly taught advanced formulas. It wasn't very helpful because it only covered a couple of items. I always try to use "help" inside of excel and that usually adds to my confusion. How can I teach myself more complicated formulas than just...
I would like to use a formula to search criteria in multiple columns. If the data in both columns matches the criteria, different set of criteria for each column, then sum figures in a another column. Example, if Obj=Bal and Tax=Non then sum "totals":
Total OBJ Tax
-------------- --- ---...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.