Is it possible to have a cell that tallies the total of all amounts in a column in which another column in that row has a letter entry? For example, if you have a row in a finance table, with venue, date, amount and method (C-cash, V=credit card and P=Paypal) columns, then cell H7 would equal all the amounts in the column in which that letter is in the method column? LIke "=total of amounts in amount column in which method column = C?
Can you see what is wrong with this custom column? There is no if function as all I need to do is create a string which has two of the columns embedded. "schtasks /change /ENABLE /tn " + [TaskName] + " /s " + [Server]
What should my next video be? Let me know below!
Power query 101
same thing but with multiple conditions like if PClass is 1 and Column PassengerID is more than or less than 100 then "Grade A".
You're the only one who made this clear! Thanks!
Glad I could help!
Is it possible to have a cell that tallies the total of all amounts in a column in which another column in that row has a letter entry? For example, if you have a row in a finance table, with venue, date, amount and method (C-cash, V=credit card and P=Paypal) columns, then cell H7 would equal all the amounts in the column in which that letter is in the method column? LIke "=total of amounts in amount column in which method column = C?
For that, try grouping by the method column and adding a sum to aggregate the amount column.
Can you see what is wrong with this custom column? There is no if function as all I need to do is create a string which has two of the columns embedded.
"schtasks /change /ENABLE /tn " + [TaskName] + " /s " + [Server]
Use &, not +.
@@excelwithpaolo Yes. I found that and couldn't find this comment to remove it... but it might help somebody so it'll stay.