M
MadWoman
I tried the formula below in my database and I get a 0 as an answer.
=SUMPRODUCT((Data!B1:B20000="Access
Nurses")*(Data!Q1:Q20000="Apr-08")*(L1:L20000))
Can someone tell me what I'm doing wrong and how to correct?
Column B contains different vendor names, column Q contains the month of the
transaction and colum L contains a subtotaled dollar amount.
=SUMPRODUCT((Data!B1:B20000="Access
Nurses")*(Data!Q1:Q20000="Apr-08")*(L1:L20000))
Can someone tell me what I'm doing wrong and how to correct?
Column B contains different vendor names, column Q contains the month of the
transaction and colum L contains a subtotaled dollar amount.