Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default SUMPRODUCT

Hey all need some help correcting this formula

=SUMPRODUCT(--(E32:AJ32="x"),--(F32:AK32<""))*20+C32

How it works is follow

Correct pick =checkmark

Incorrect pick = X

If X is followed by anther selection then multiple it by $20

The problem Im having is if the result is X and I skip one cell its not
adding the $20
Even if I skip one cell it should add the $20 if another pick is adding
along this cell area.

Thanks ahead

 
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
Conditional SUMPRODUCT or SUMPRODUCT with Filters Ted M H Excel Worksheet Functions 4 August 14th 08 07:50 PM
Help with SUMPRODUCT please : ) Sierra Excel Worksheet Functions 5 November 8th 07 01:04 AM
sumproduct? sumif(sumproduct)? David Excel Worksheet Functions 3 July 13th 07 07:06 PM
Help with SUMPRODUCT FrankTimJr Excel Discussion (Misc queries) 4 October 12th 05 04:27 PM
sumproduct? cursednomore Excel Worksheet Functions 2 October 10th 05 08:45 PM


All times are GMT +1. The time now is 02:31 AM.

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"