IF Formula Help

[holly_29]

Hey

I want cell 04 to keep adding 7.5 everytime a cell from G4:GM has the word hols is in it. What formula would i put?

Thanks.

[Richard Buttrey]

Hi,

Is there a typo there. What's the range? G4:G???

Assuming it's something like say G4:G23 what's the requirement here. If 10 of those cells have 'hols' should O4 show 75. i.e. 10*7.5

If so then

Please Login or Register  to view this content.