Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Haz Haz is offline
external usenet poster
 
Posts: 46
Default Sum If Help

I'm trying to sums up the total for different vendors with mulitple entries,
but I have payments and invoice amounts in the same column. I only want to
add up invoices. My data looks like this, I think I need a count if function
I think but i can't get it to work.

Col b Col D Col G (£) Col I
Access Invoice 500 Sum up only invoice
Amounts leaving out
Access Payment 500 Payment value
Acesss Invoice 400
Argosy Invoice 300
Argosy Payment 300

Is is Count If or sum if ?
Any assistance would be appreciated
Thank You
 
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



All times are GMT +1. The time now is 12:54 PM.

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

About Us

"It's about Microsoft Excel"