ExcelBanter - enter 2 formulas into 1 cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - enter 2 formulas into 1 cell (https://www.excelbanter.com/excel-discussion-misc-queries/164265-enter-2-formulas-into-1-cell.html)

Needs help

enter 2 formulas into 1 cell

I need to create 1 formula in cell f94 that adds my cells but it has to meet
2 criteria. example...I need my formula to count the cells in f2:f86 only if
it says "internet" and only if it contains a number in cells m2:m86. Please
help! thanks

Gary''s Student

enter 2 formulas into 1 cell

=SUMPRODUCT(--(F2:F86="internet"),--(M2:M86<0))

--
Gary''s Student - gsnu200752

Teethless mama

enter 2 formulas into 1 cell

=SUMPRODUCT(--(F2:F86="internet"),--(ISNUMBER(M2:M86)))

"Needs help" wrote:

I need to create 1 formula in cell f94 that adds my cells but it has to meet
2 criteria. example...I need my formula to count the cells in f2:f86 only if
it says "internet" and only if it contains a number in cells m2:m86. Please
help! thanks

All times are GMT +1. The time now is 03:57 PM.