Hello
IN H2 = if G1 is greater than 1, Sum D,E,F,G (can this be done in one formula)
Please see attahed example:
paul
Hello
IN H2 = if G1 is greater than 1, Sum D,E,F,G (can this be done in one formula)
Please see attahed example:
paul
Hi Paul,
Pop this in cell H2 and copy it down.
=IF(G2>1,SUM(D2:G2),0)
NB - Based on your expected results I've assumed that you mean the relevant row in column G is greater than 1 rather than cell G1 explicitly.
I hope this helps? If you have any queries or need it tweaking just give me a shout.
Regards,
Snook
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks