Formula

curabaysevket · September 4, 2024, 1:35pm

I want to create a formula in Cell E1. I want to add the G13 subtable values of the (Aktif) (Taahhüt) and (S.Teslimi) selected in the H13 Subtable. I would be happy if you could help.

ting · September 6, 2024, 3:05am

Hi,

To achieve what you’re aiming for in cell E1, you can use the SUMIF() formula to sum the values in G13 that meet the conditions in H13. Here’s the formula you can apply:

SUMIF(H13, “Aktif”, G13) + SUMIF(H13, “Taahhüt”, G13) + SUMIF(H13, “S.Teslimi”, G13)

This formula will add the G13 values that correspond to “Aktif”, “Taahhüt”, and “S.Teslimi” in the H13 subtable.

curabaysevket · September 6, 2024, 7:00am

thanks for answer but I get a warning

Your formula contains an error. Please make sure that all parentheses are part of a matching pair, and whether you have entered all required arguments.

ting · September 6, 2024, 7:37am

Hi,

I tested it on my sheet, and it seems to work fine. Do you happen to have a screenshot ? It could help check if there are any incorrect symbols in the formula.