0

I am looking for help with Google Sheets formula.

The formula I need is -

If A:A=LG and F:F=Indexed then sum the total of P:P for all of those instances.

If A:A=PG and F:F=Indexed then sum the total of P:P for all of those instances.

If A:A=LG and F:F=Fixed then sum the total of P:P for all of those instances.

If A:A=PG and F:F=Fixed then sum the total of P:P for all of those instances.

for example this formula SHOULD make JV Fixed = $27,000 and JV Indexed = $160,000

Here is a condensed version of my actual sheet,

enter image description here

Im sure this is simple for someone, but I'm not that great with formulas :)

1

If you're trying to SUM() a column based on criteria, then SUMIF() or SUMIFS() would get you what you want. In this example you could use SUMIFS()

=SUMIFS(P:P, A:A, "PG", F, "Indexed") - this gives you a SUM of values in P where Column A = "PG" and Column F = "Indexed". You could extend these criteria for as many filters as you need.

You'd then change this formula for the various criteria you want.

For more info, check out the Help Center article on SUMIFS()

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.