"IF" statement in a pivot table.
 

I need help in writing a "IF" statement in a pivot table. My data consists
of sale orders numbers that may have several line items - I am trying to do a
count on the sale orders and Excel count each item as a separate sales order.
Is it possible to write a "IF" statement in a pivot table? Does anyone have
any suggestions as to how I should approach this?

Elizabeth

If you have an order # them leave out the items and then simply set the
order # to 'count'. You will not be able to count the unique orders in the
table with the items in (AFAIK), as Excel will count every occurrence of an
order # even if this is only to mark 3 items on the order

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Elizabeth" wrote in message
...
I need help in writing a "IF" statement in a pivot table. My data consists
of sale orders numbers that may have several line items - I am trying to
do a
count on the sale orders and Excel count each item as a separate sales
order.
Is it possible to write a "IF" statement in a pivot table? Does anyone
have
any suggestions as to how I should approach this?