hi,

i have a spread sheet with a column E that can either be WM or some other desigination.
Column H can be either Y or N and column F is a $ amount.

I am trying to total all of the $ amounts in column F when E is WM and H is . Below are 2 formulas I have tried from my online readings to no avail. Anyone have a suggestion as to how to achieve this?


=SUM((E4:E100="WM")*(H4:H100="Y")*(F4:F10))

=SUM(IF((E4:E100="WM")+(H4:H100="Y"))F4:F100))

2nd part, I am also trying to creat a tally of the # of times the column E is WM and Column H is Y. What the best way to do this?

Thanks in advance.