SumIfs

[gheyman]

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

 

[Fluff]

Upto 127 range/criteria pairs according to this https://support.office.com/en-us/article/countifs-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842

 

[gheyman]

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]

In that case you'll be fine