I need to insert a SUMIF and AND into a function to test two ranges of cells for correct response.
I cannot see how to combine the SUMIF and the AND functions.
For example:
sum cells a1:a55 if cell b1:b55 contain '1' and cell c1:c55 contains 'y'
Anyone help?
Thanks
I cannot see how to combine the SUMIF and the AND functions.
For example:
sum cells a1:a55 if cell b1:b55 contain '1' and cell c1:c55 contains 'y'
Anyone help?
Thanks