I cannot perform this function PLEASE HELP!
Hi Im trying to combine an IF statement with a COUNTIF statement, the fuction
is below:
=COUNTIF('Events Due August'!F2:'Events Due August'!F1206,'Customer Data
Sheet'!B7)*IF('Events Due August'!B:B,'Customer Data Sheet'!C3:E3)
So basiclly its trying to look up the total count of a column with a certain
event description for a certain customer. Its not working what am I doing
wrong??
Can someone let me know, thanks!
Sunny
|