View Single Post
  #1   Report Post  
KathyP143 KathyP143 is offline
Junior Member
 
Posts: 1
Default State Tax Business Calculations Help

Urgg.. I've been trying to figure out this one for days and it's eating 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 spreadsheet
Attached Files
File Type: zip ACCOUNTING.zip (5.3 KB, 33 views)