# Search:

Type: Posts; User: LordEvil; Keyword(s):

1. ## Thread: Help with SUMIF formula

by LordEvil
Replies
4
Views
199

### Re: Help with SUMIF formula

This ended up working which is weird because it is almost the same formula, just removed the specific cell set of 2 : 20000.
=SUMIFS(Sheet2!H:H,Sheet2!D:D,I1,Sheet2!E:E,J1)
2. ## Thread: Help with SUMIF formula

by LordEvil
Replies
4
Views
199

### Help with SUMIF formula

Hi everyone,

I've tried reading a lot of articles in excel support with no luck. I am trying to do a sumif formula but i keep getting a zero when there is clearly data to be calculated.

I have...
3. ## Thread: ISBLANK question conditional formatting

by LordEvil
Replies
6
Views
230

### Re: ISBLANK question conditional formatting

Thanks guys, that worked. I will have to read up on the AND function.
4. ## Thread: ISBLANK question conditional formatting

by LordEvil
Replies
6
Views
230

### ISBLANK question conditional formatting

Hi, I have a lot of dates from D3:D54. I would like to set up conditional formatting to show them red if they are past due. How can I make the blank cells not show any color format?

I must be...

by LordEvil
Replies
3
Views
191

Thank you!
6. ## Thread: Need help with formula (If)

by LordEvil
Replies
3
Views
191

### Need help with formula (If)

https://drive.google.com/file/d/1IBhyYe0tBCGUKU1kYMXzA59a26eY1rIo/view?usp=sharingI have a drop down list in columns B7, B8 and B9. Its a simple Yes or No selection

I would like if B7 - Yes then...
7. ## Thread: Count names on another sheet that fall on a certain date

by LordEvil
Replies
0
Views
196

### Count names on another sheet that fall on a certain date

Hi all,

I have a workbook that logs daily production totals. I am able to count totals for production between dates but for the life of me are unable to figure out how to count the employees. I'm...
8. ## Thread: Conditional Format Question

by LordEvil
Replies
1
Views
173

### Conditional Format Question

Hi All,

I have an excel spreadsheet that I would like to identify (red text, pink background) where values in D3:D50 on sheet 1 equal any value in sheet2 G3:G50