Excel Excel help please

M

MRBLUE

Joined
Aug 24, 2013
Messages
3
Reaction score
0
Tring to use multiple arguements in a excel sheet.

On sheet January I have Countifs searching for a repeated id number

=COUNTIFS(January!D5250,"33247
This will record a single digit if a number is present in another cell
,January!G5:G250,"2*")

Completed it looks like this
=COUNTIFS(January!D5250,"33247",January!G5:G250,"2*")

Now I want it not to subtract a number in E3 of worksheet Tickets if no text exsist in
January!F5:F250

If text exsist no change,,, The text is added from data validation

Have been working on this all day ,,,
 
Try the following:

Code: 
=IF(COUNTA(January!F5:F250)>0,COUNTIFS(January!D5250,"33247",January!G5:G250,"2*"),COUNTIFS(January!D5250,"33247",January!G5:G250,"2*")-E3)

I think that will do what you're looking for. It will examine to see if all of the cells in F5:F250 are blank. If all of them are blank, it will do the subtraction listed at the end. If at least 1 of the cells in that range is not blank, it will do the first COUNTIFS without subtraction. Another caveat to keep in mind with this formula is that it will only work if the cells with the numbers being referenced in the COUNTIFS statement are formatted as Text. If they are numeric values, it won't work. Let me know if that does it for you!
 
Close, it removes the total from F3 not E3.

Just to clarify, In January!D5:D250 when a id number is added I need it to count one in E3(on another sheet) When G5:G250 has a number starting in 2 I need a total of one in F3(on another sheet) If text is entered from a drop down list in F5:F250 then I need to subtract one from E3.

The formula you sent is close I will have a look and see If I can alter to complete the taskl, However and assistance further is greatly appreciated.
 
if you can give me a more full explanation I can try to narrow it down, but I'm not quite following you.
 
I have one sheet per month, When each employee completes a project, I will add their identification number to the sheet (their name populates) the identification number is added to D5:D250. With the presence of their identification number I want them to get a score of one on the "tota"l page in colum E3-E250. If the employee required assistence from another employee a ID number is added to colum G5-G250 on the january sheet.The assistance from another employee will result in a total of one on the "total" sheet in F3:F250. On the January sheet the employee needs to use the drop down list on F5:F250 with cause for help. If the cause for help is not filled in (left blank) the employee loses his total on the Total Sheet under E3:E250

The monthly sheet looks like this
NAME ID # D5:D250DATETYPE (F5:F250)Helper
G5:G250


A employees name may be listed multiple times.

My original question worked except I struggled with when the Type field was not used....
 
Back
Top