A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Getting Count field to recognise rows with negative values in Exc.



 
 
Thread Tools Display Modes
  #1  
Old June 17th, 2005, 07:03 AM
hamish
external usenet poster
 
Posts: n/a
Default Getting Count field to recognise rows with negative values in Exc.

I am using a Pivot table to Count the number of changes occurring against a
project. The Count is against whether the change is Approved or Rejected.
This works fine until I add a 3rd element. Some changes have a negative
financial impact, others positive. Those rows with negative value do not show
up in the Count. Where am I going wrong?

Columns on the source data table a Change Request No; Aligned Project No
(1-6); Status (Approved/Rejected); Financial value

Pivot table data: Rows = Aligned Project; Columns = Status; Data = Count of
Change Requests & Sum of Financial value
  #2  
Old June 17th, 2005, 09:51 AM
virendra.telkar
external usenet poster
 
Posts: n/a
Default


hi,

please give more details, u can also mail me on


regards,

virendra


--
virendra.telkar
------------------------------------------------------------------------
virendra.telkar's Profile:
http://www.excelforum.com/member.php...o&userid=24275
View this thread: http://www.excelforum.com/showthread...hreadid=379999

  #3  
Old June 20th, 2005, 05:06 AM
hamish
external usenet poster
 
Posts: n/a
Default

Thanks - resolved problem

"virendra.telkar" wrote:


hi,

please give more details, u can also mail me on


regards,

virendra


--
virendra.telkar
------------------------------------------------------------------------
virendra.telkar's Profile:
http://www.excelforum.com/member.php...o&userid=24275
View this thread: http://www.excelforum.com/showthread...hreadid=379999


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Here's a shocker Mike Labosh General Discussion 2 October 26th, 2004 05:04 PM
how do i count rows, and count them by color or a highlight? blue. adam Worksheet Functions 1 September 9th, 2004 10:05 PM
Count Characters in a field Donna I-don't-know-VBA-fully-yet Using Forms 1 August 13th, 2004 10:52 PM
ASK Field Behavior Greg Mailmerge 9 July 2nd, 2004 02:44 PM
Supress blank lines in DOCPROPERTY field Mary Formatting Long Documents 10 May 25th, 2004 07:27 PM


All times are GMT +1. The time now is 05:35 PM.


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