Formula to sum column with multi criteria in other columns

Because of the "Or" requirement for column C, the formula needs to be structured as a sum if. I've converted the Daten_CIE data to an excel table CTRL + T for ease of reference. I'd recommend storing the times required for the condition in hiddn cells in the "Dedicated" page against each time bucket. Also be careful of counting twice, for example 00:00 and 01:00 in the same time bucket.

=SUMPRODUCT((Table1[totNIncomeLT])*(Table1[Thema]="GEV 0192624")*((Table1[von]="00:00")+(Table1[von]="00:30")+(Table1[von]="01:00")))

edit: Glenn's is the cleaner solution.

Or...

Separate von and bis into separate columns. Format as [h]:mm

Convert the text-times in CIE.... to real times: Select column C. Data/Text to columns/Finish. Repeat for column D.

Then use:

=SUMIFS(Daten_CIE!E:E,Daten_CIE!A:A,"GEV 0192624",Daten_CIE!C:C,">="&N3,Daten_CIE!D:D,"<"&O3)

Copy down the column.

There is a logical inconsistency in your requirement. If in the first row you count 0:00 0:30 and 01:00, what do you count in the second?? 01:00 again?? or what. In my suggestion, you count 0:00 to0:059:59 in the first row; 01:00 to 01:59:59 in the second, etc.

Like this:

=SUM(SUMIFS(Daten_CIE!E:E,Daten_CIE!A:A,{"GEV 0192624","GEV Inland"},Daten_CIE!C:C,">="&N3,Daten_CIE!D:D,"<"&O3))

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.