Thread: sumif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rich[_18_] Rich[_18_] is offline
external usenet poster
 
Posts: 1
Default sumif

In the sumif function is there any way of having two
criteria.

=sumif(Portfol!AF:AF,"21",Portfol!W:W)

for example the criteria here is "21" chosen from column
AF I also need "A" chosen from column K.

Basically is there a formula that can have 2 criterias to
get a sum of data.