View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sunny Sunny is offline
external usenet poster
 
Posts: 42
Default 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