LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
scott
 
Posts: n/a
Default Still having trouble

I want to return information per month.

Can I do something like this;

=IF(MONTH=APRIL,COUNTIF(B:B,"CUSTOMER ERROR"),)

Obviously MONTH=APRIL is not the proper language, but I am having trouble
using other date functions.

I want to return a number of how many times a customer caused the default in
an order per month.

This was reccomended earlier:
=SUMPRODUCT(--(S2:S999="CUSTOMER ERROR"),--(MONTH(B2:B999)=5))

Still didn't work. Maybe a dumb question, but what does the "--" mean?

Any help is appreciated.
Thanks so much
Scott
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trouble Forecasting PaulW Excel Discussion (Misc queries) 1 April 26th 06 03:24 PM
Trouble with formulas kevhatch Excel Discussion (Misc queries) 2 January 23rd 06 01:52 AM
UGH! Trouble downloading, and opening anything cali Excel Discussion (Misc queries) 1 December 15th 05 06:36 AM
still having trouble with this.... nick Excel Worksheet Functions 4 March 13th 05 07:40 PM
I have had trouble with textbox text to worksheet Thomas Excel Discussion (Misc queries) 1 March 10th 05 03:23 AM


All times are GMT +1. The time now is 06:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"