Tristram_ZX81
New Member
- Joined
- Jun 22, 2021
- Messages
- 45
- Office Version
- 365
- Platform
- Windows
I'm using Excel 365. I've been using formula like the one below to count information. So it finds any row with American Football written in the J column that kicks off between 21:01 and 22:00 inthe I column and repeats the corresponding number in the C column.
=SUMIFS('PBi LMS Data'!C4:C1000, 'PBi LMS Data'!I4:I1000, ">=21:01:00", 'PBi LMS Data'!I4:I1000, "<=22:00:00", 'PBi LMS Data'!F4:F1000, "Saturday*", 'PBi LMS Data'!J4:J1000, "American Football*")
I've tried to do the same with the below but I need to alter it so it looks for any instance of the two words 'Zona Gol' rather than a cells that only contains those two words (so for example I need it to count that row even if the L column says 2022 Zona Gol May). Does anyone know how I'd update that please?
#SUMIFS('PBi LMS Data'!C4:C1000, 'PBi LMS Data'!I4:I1000, ">#21:01:00", 'PBi LMS Data'!I4:I1000, "<#22:00:00", 'PBi LMS Data'!F4:F1000, "Saturday*", 'PBi LMS Data'!L4:L1000, "Zona Gol*")
=SUMIFS('PBi LMS Data'!C4:C1000, 'PBi LMS Data'!I4:I1000, ">=21:01:00", 'PBi LMS Data'!I4:I1000, "<=22:00:00", 'PBi LMS Data'!F4:F1000, "Saturday*", 'PBi LMS Data'!J4:J1000, "American Football*")
I've tried to do the same with the below but I need to alter it so it looks for any instance of the two words 'Zona Gol' rather than a cells that only contains those two words (so for example I need it to count that row even if the L column says 2022 Zona Gol May). Does anyone know how I'd update that please?
#SUMIFS('PBi LMS Data'!C4:C1000, 'PBi LMS Data'!I4:I1000, ">#21:01:00", 'PBi LMS Data'!I4:I1000, "<#22:00:00", 'PBi LMS Data'!F4:F1000, "Saturday*", 'PBi LMS Data'!L4:L1000, "Zona Gol*")