How to Use COUNTIFS Function with AND/OR Logic

Опубликовано: 03 Ноябрь 2024
на канале: CrispExcel Training & Consulting

22,561

=SUM(COUNTIFS(tblSales[Product],I2:I3,tblSales[Currency],I4))

The only trick to remember is that when using the OR criteria, highlight all criteria

#Excel #ExcelTips #exceltricks #acccounting

481

00:00:00

KATEZLATA/Посылка из Японии:)

1,925,242

38 тыс

53 Hours on Australia's Luxury Outback Train

1,767

Planet Crafter: How to Survive When the Planet Wants You Dead?

2,959,492

48 тыс

Hanybal - STREETLIFE mit Krime [Official Video]

Legacy of Discord Furious Wings Android iOS Game

1,438

Before & After - What do you think?

14,940

188

Minecraft Survival Longplay 1.20 - Episode 2 - Bringing Villagers To The Base (No Commentary)

3,437

Virtual Layer in QGIS