Posted to microsoft.public.excel.worksheet.functions

mass

external usenet poster

Posts: 7

sumproduct text if

I am trying to use a sumproduct function with IF and Text.
I want to see that if the value of the sumproduct function is "blank" or
"specific text" then return another value, if not then return the value of
the sumproduct function
Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
maybe by sumproduct or some other way with text.	driller	Excel Worksheet Functions	4	June 5th 07 08:54 AM
SUMPRODUCT but with text containing	Fiona	Excel Worksheet Functions	5	November 24th 06 09:46 AM
Is there a SUMPRODUCT-like function that I can use on text?	[email protected]	Excel Worksheet Functions	2	January 11th 06 05:50 PM
Sumproduct Text	tamato43	Excel Discussion (Misc queries)	1	June 5th 05 04:48 PM
SUMPRODUCT vs Text???	Ken	Excel Worksheet Functions	2	April 9th 05 07:21 PM

All times are GMT +1. The time now is 08:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us