Accounting Excel Sheet Formula's
Dear Friends,
May I be please assisted with the following formula's to an Accounts sheet I created. It is attached.
A) If B4 contains letter "C", and C5 contains "Expense" Then add the total sum to H6.
B) If B4:B200 contains letter "B" and C5:C200 contains "CollectedMoney" Then add the total sum to l10
C) If B5 contains the letter "C" and D5 contains "MoneyCollected" Then add sum total to l19
D) How to I track amounts that are Undeposited for H11?
Thank you!
Please add sample data and expected results.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
A) If B4 contains letter "C", and C5 contains "Expense" Then add the total sum to H6.
Expected Result: Dynamically total the amount of money added by above parameter to H6.
B) If B4:B200 contains letter "B" and C5:C200 contains "CollectedMoney" Then add the total sum to l10
Expected Result: Dynamically total the amount of money to l10
C) If B5 contains the letter "C" and D5 contains "MoneyCollected" Then add sum total to l19
Expected Result: Dynamically total the amount of money to l19
D) How to I track amounts that are Undeposited for H11?
Exexted Result: as "MoneyDeposit" are made, calculate how much money that was collected on hand, but not deposited to hte bank,
and add the answer to l19
Please add expected results... as requested. We do not know where the amounts in D & E are meant to go!!
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
In H6
=SUMIFS($E$5:$E$8,$C$5:$C$8,"Expense",$B$5:$B$8,"C")
what about text in this cell???
Similar formula for other criteria.
re H!!
"Deposied Moey" - "Collected Money" ??
The expected results are shown above. If there is something different you request, please do care to explain.
There is nothing in columns H & I. Please do as requested.
Hi Glenn & John,
I have done as requested. If you wish me to clarify anything else, please try and explain fully without being angry or frustrated.
I have attached the sheet again and changed the questions below to be more accurate. Thank you!
A) If B5:B200 contains letter "C", and C5:C200 contains "Expense" Then add the total sum to H7.
Expected Result: Dynamically total the amount of money added by above parameter to H7.
B) If B5:B200 contains letter "B" and C5:C200 contains "CollectedMoney" Then add the total sum to l9
Expected Result: Dynamically total the amount of money to l9
C) If B5:B200 contains the letter "C" and D5:D200 contains "CollectedMoney" Then add sum total to l19
Expected Result: Dynamically total the amount of money to l19
D) How to I track amounts that are Undeposited for H11?
Exexted Result: as "MoneyDeposit" are made, calculate how much money that was collected on hand, but not deposited to hte bank,
and add the answer to l19
This is hopeless!
A) If B5:B200 contains letter "C", and C5:C200 contains "Expense" Then add the total sum to H7. Expected Result: Dynamically total the amount of money added by above parameter to H7.
What total amount of money? The total in column D or column E or both combined... or what??????
Alright. Let's close this thread. I will work on this sheet. Thank you for your help.
Whatever... suit yourself.
It is a simple Q I asked. Is it the total from column D or column E you want???
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks