Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What function does ^ perform in a formula | Excel Worksheet Functions | |||
perform 1 function, stop, perform different function | Excel Discussion (Misc queries) | |||
How to perform the following function in Excel? | Excel Worksheet Functions | |||
How do I perform an IF function on Microsoft excel? | Excel Discussion (Misc queries) | |||
How do I perform a contains function for a specific cell? | Excel Worksheet Functions |