LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bkt bkt is offline
external usenet poster
 
Posts: 5
Default Please help w/Sumproduct!

Hi,

Looking for a Sumproduct formula that will add the quantities in Col. C that
have (A in Col. A & "whatever" in Col. B) + Only those Quantities in Col. C
that have (Blanks in Col. A & Non-Blanks in Col. B)

Col. A Col. B Col. C
F Blank 10
A Blank 20
Blank Blank 30
F Non-Blank 40
A Non-Blank 30
Blank Non-Blank 20

Eg: 20 + 30 + 20 = 70

Thanks in advance,
bkt
 
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
Compare row contents w/Sumproduct or Array formula? uw805 Excel Worksheet Functions 5 June 6th 06 07:09 AM


All times are GMT +1. The time now is 11:44 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"