State Tax Business Calculations Help

[KathyP143]

Urgg.. I've been trying to figure out this one for days and it's eatin
my lunch.. What I need F20 to do is this:

If B2:B10 does not contain the abbreviation "OK"
And H2:H10 does not have a dollar amount in it
then add the total of G2:G10

(B2:B10,"<>ok",H2:H10,"=0",G2:G10)

attached is my excel spreadshee

+-------------------------------------------------------------------
|Filename: ACCOUNTING.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=937
+-------------------------------------------------------------------

 

[Claus Busch]

Hi Kathy,

Am Fri, 10 Jan 2014 14:10:07 +0000 schrieb KathyP143:

(B2:B10,"<>ok",H2:H10,"=0",G2:G10)

try:
=SUMPRODUCT(--(B2:B10<>"ok"),--(H2:H10=0),G2:G10)


Regards
Claus B.