sumif

[Rich]

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.

 

[JMay]

=SUMPRODUCT((AF2:AF100=21)*(K2:K100="A")*(AG2:AG100))
Change Ranges to accomodate your data; Also Column AG is what you are
"totaling/summing".
HTH

 

[rich]

that was great it works thanks a lot

-----Original Message-----
=SUMPRODUCT((AF2:AF100=21)*(K2:K100="A")*(AG2:AG100))
Change Ranges to accomodate your data; Also Column AG is what you are
"totaling/summing".
HTH





.