SumIfs

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,742
Office Version
  1. 365
Platform
  1. Windows
In a SumIfs formula (Ifs not If) how many criteria's can you have?

=SUMIFS(K$8:K25,$P$8:$P25,$Q25,$Q$8:$Q25,$R25,$R$8:$R25,$S25,$S$8:$S25,$T25)
Example this one has 4
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,742
Office Version
  1. 365
Platform
  1. Windows
Thanks, Fluff. I did a search but went through several articles with non of them stating a limit. I was just curious. I only needed 9.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,339
Office Version
  1. 365
Platform
  1. Windows
In that case you'll be fine
 

Watch MrExcel Video

Forum statistics

Threads
1,109,009
Messages
5,526,258
Members
409,689
Latest member
martin_br

This Week's Hot Topics

Top