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.

sumif
 

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


"Rich" wrote in message
...
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.

sumif
 

that was great it works thanks a lot
-----Original Message-----
=SUMPRODUCT((AF2:AF100=21)*(K2:K100="A")*(AG2:AG10 0))
Change Ranges to accomodate your data; Also Column AG is
what you are
"totaling/summing".
HTH


"Rich" wrote in message
...
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.


.