About Us

Cindi

I have several cells involved in this IF statement. I've tried to do a
SUMIF, but I can't get it to work. Can someone help me please?

=IF($I$33="No",(+H33*D50))+IF($I$33="Yes",0)+IF($I $34="No",(+H34*D50))+IF($I$34="Yes",0)+IF($I$35="N o",(+H35*D50))+IF($I$35="Yes",0)+IF($I$36="No",(+H 36*D50))+IF($I$36="Yes",0)+IF($I$37="No",(+H37*D50 ))+IF($I$37="Yes",0)+IF($I$38="No",(+H38*D50))+IF( $I$38="Yes",0)+IF($I$39="No",(+H39*D50))+IF($I$39= "Yes",0)+IF($I$40="No",(+H40*D50))+IF($I$40="Yes", 0)+IF($I$41="No",(+H41*D50))+IF($I$41="Yes",0)+IF( $I$43="No",(+H43*D50))+IF($I$43="Yes",0)+IF($I$56= "No",(+H56*D50))+IF($I$56="Yes",0)+IF($I$57="No",( +H57*D50))+IF($I$57="Yes",0)+IF($I$58="No",(+H58*D 50))+IF($I$58="Yes",0)
--
Cindi H

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Reconcile Bank statement & Credit card statement & accounting data	Bklynhyc	Excel Worksheet Functions	0	October 7th 09 09:07 PM
Iserror is too cumbersome as I use it - is there an alternative?	[email protected]	Excel Worksheet Functions	5	January 9th 08 11:07 PM
Non cumbersome way to hide and protect a column?	[email protected]	Excel Worksheet Functions	2	March 23rd 07 02:33 AM
nested IF AND too cumbersome	barnabas	Excel Worksheet Functions	4	January 31st 07 02:00 PM
cumbersome sheets on Word	Luke	Excel Worksheet Functions	2	September 24th 05 03:25 PM

Menu

About Us