Combining an IF and SUMIF statement, also Typing a string and excel will finish it

[guruman]

Hi,

Currently I have a formula like this:
=SUMIF(Buys!A:A,'Available Money'!A4,Buys!$J$1:$J$38)
so basically if column A equals AI2A then sum whats in J. Now I cam
across an issue, these items can be bought in Canadian or US Dollars
so I need it to sum if it equals AI2A and another column equals USD
Any thoughts on how to combine these two formulas, or what will work?

Second, is I want excel to be able to find something I've types an
want to finish it. So, I have the days of the week listed on anothe
worksheet, so that when I type Friday, all I need to type if "F" and i
will bring up friday, and all I have to do is hit enter and Friday wil
be in that cell. This is only for certain cells though.

Comments, suggestions and help are appreciated.

Thank you

 

[Max]

Currently I have a formula like this:
=SUMIF(Buys!A:A,'Available Money'!A4,Buys!$J$1:$J$38)
so basically if column A equals AI2A then sum whats in J. Now I came
across an issue, these items can be bought in Canadian or US Dollars,
so I need it to sum if it equals AI2A and another column equals USD.
Any thoughts on how to combine these two formulas, or what will work?

Try something like (untested)

:
=SUMPRODUCT((Buys!$A$1:$A$100="AI2A")*(Buys!$B$1:$B$100="USD"),Buys!$J$1:$J$
100)

assuming col B in sheet: Buys is where "USD" will reside

Note: Entire col refs (A:A, B:B, J:J etc) cannot be used in SUMPRODUCT

Second, is I want excel to be able to find something I've types and
want to finish it. So, I have the days of the week listed on another
worksheet, so that when I type Friday, all I need to type if "F" and it
will bring up friday, and all I have to do is hit enter and Friday will
be in that cell. This is only for certain cells though.

Try Tools > Autocorrect
Replace: F
With: Friday
Click OK

Test it out by typing an "F" in an empty cell
Press Enter, and "Friday" will be there