Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help in excel I want to format a cell so that it reads from the column who to read specific text of the
I need help in excel
I want to format a cell so that it reads from the column who to read specific text of the name of person
then it will read which category, then if category matches specific text - it will take that amount and add it.
This is for personal expense for my family, I just want the excel cell to see who spent, in which category, then add all the values up so its in one place.
\begin{tabular}{|c|c|c|c|c|c|} \hline & \multicolumn{5}{|c|}{ Spendin of the Month () } \\ \hline Who & Date & Cat & gory & nount & Comment (If Applicable \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|} \hline \multicolumn{3}{|c|}{ Tracker } \\ \hline \multicolumn{3}{|c|}{} & \\ \hline Category & Amount & Category & Amount \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started