Thread
:
sumproduct with one variable criteria?
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Cif
external usenet poster
Posts: 4
sumproduct with one variable criteria?
hi, i am interested doing something like this:
=SUMPRODUCT(--(B1:B12="criteria 1");--(M1:M12=B29);--(I1:I12))
where B29 represent a value that i introduce in cell b29
thanks in advance
Reply With Quote
Cif
View Public Profile
Find all posts by Cif