Hi
I need some help on a formula in cell E17 of the Summary Tab of the attached spreadsheet which will sum all the amounts for the 6 months for ‘Short Term Care’ for the ‘Metro’ area for the year FY 2023 by looking up all the values and descriptions in the ‘Output-Detailed Costs. Similarly for...
Hi Guys
I need help on a formula. In the attached spreadsheet i need a formula say starting from cell C6 which says if the amount in that cell reaches total loan amount of $8m then the next cell to cell d7 should be zero.
Please help
Just for your knowledge. I finally managed to find a solution to my formula. There was no need of pivots. This is the simple formula. Perhaps may assist you in the future.
=SUMIFS(Costs!H$6:H$219,Costs!$B$6:$B$219,$C5,Costs!$C$6:$C$219,$D$2)
Hi.
Please can someone help me.
In the attached spreadsheet, i am looking for a formula in the summary tab in cell E13 which will look at the value or text in cell C6 (summary tab) then compare it to the range of the same value or text in the costs tab from cells C6:C219 and also look at the...
The whole purpose a formulae is not provided is because i dont have one. Hence i am asking for help. Regarding effort from my part, i would not be reaching out had i not tried before. Whether its an assignment or not, what does it matter. This is a platform to assist people in excel. Anyway thanks.
Thank you for your reply.
This is not a trap but something work related that i am stuck on. Besides i thought this forum was to assist those who need assistance on excel regardless of what it is.
Thanks
Hi.
In the attached spreadsheet, i am looking for a formula in the summary tab in cell E13 which will look at the value or text in cell C6 (summary tab) then compare it to the range of the same value or text in the costs tab from cells C6:C219 and also look at the value in summary tab cell c12...
Hi
I am trying to get a formula in say cells D4 to R4 which will return the value in cells B7 to B11 based on the year it occurred.
Say for example from data highlighted in the table in orange (from Cells A7 to B11) in year 3 5 units were sold therefore this number should appear in cell F4...
In the attached spreadsheet i want a formula total amount amount in cell d10 which reflects the month in cell d7. So far example if D7 is April 20 then the formula should look at rows d14 to l14 (months) and sum everything in that column. For now i have manually inserted the amount.
Hi all
I needed help on a formula.
In the attached spreadsheet i have in cells c3 to c6 the time when a purchase is intended to be made and in cells d3 to d6 the amount.
In cells from e10 to n13 i want a formula that will pick the time the purchase is intended to be made and put the...