I need to sum only the values out of a third column if those meet the criteria from two other columns such as if cells in column a =char(78) and cells in column b = char(89) then sum the values in column 3 ---- similar to sumif but I need to add in another range and criteria
If you have XL2007 or XL2010, you can use the similar function SUMIFS which allows multiple criteria.
e.g.
=SUMIFS(C:C,A:A,CHAR(78),B:B,CHAR(89)) where C:C is the sum column in this function
or if you don't have those versions, use SUMPRODUCT
e.g.
=SUMPRODUCT(--(A1:A100=CHAR(78)),--(B1:B100=CHAR(89)),C1:C100)
Note: cannot use whole columns with Sumproduct in pre XL2007
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I have lx03 and doesn't sumproduct only counts the occurences not the values in the cells
Sumproduct is very flexible and can be used to end up summing cell values according to conditions... see this article for more: Sumproduct
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks