LinkBack URL
About LinkBacks
Hi there,
I have had a go, but going wrong somewhere, would appreciate your help please?
Please see attached.
In cell H2, I want the total of column F when column C is Finance Costs and Loan Costs. I.e cell H2 should total 171,267.10
Thanks all
N
Hi there,
I have had a go, but going wrong somewhere, would appreciate your help please?
Please see attached.
In cell H2, I want the total of column F when column C is Finance Costs and Loan Costs. I.e cell H2 should total 171,267.10
Thanks all
N
SUMIFS criteria use "AND", not "OR". Since you only have two criteria, adding two SUMIF functions should suffice:
=SUMIF(C:C,"Finance Costs",F:F)+SUMIF(C:C,"Loan Costs",F:F)
Hi there,
Thanks for quick reply and for solving my problem.
For future reference, I would be grateful if you can show how the formula would be different if I were to use the OR function for future problems and not AND?
Thanks again
Try...
=SUM(SUMIFS(F:F,C:C,{"Finance Costs","Loan Costs"}))
HTH
Regards, Jeff
Hi Jeff,
Just trying this, but I am trying to apply the formula to another tab.
Are you able to rewrite the formula if the formula were in sheet 2 please?
Regards
Hi N,
=SUM(SUMIFS(Sheet1!F:F,Sheet1!C:C,{"Finance Costs","Loan Costs"}))
If you paste the formula from post #4 into sheet 1, you can then cut & paste the formula to whatever sheet you like. The references will auto update.
Perfect, Thanks so much to all
You are very welcome. We are happy to help.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks