Array Formula

C

Chris waller

I have an array formula that is summarising data from 3 spreadsheets,
however, I need to know how I can modify part of the formula so it will sum
different data. If you look at the formula you will see that it is
summarising the data where there is nothing in column F, however, I need to
be able to modify the formula so that it will sum both cells that contain
nothing and also if they contain certain phrases within a string of text.
There are possibly a dozen different variations and the cell can also contain
dates. I am not so bothered about the dates as these will all be different,
it is only if the cells that contain phrases that I am trying to identify and
summarise. TIA

=SUM((Sheet2!$C$3:$C$31="HEO")*(Sheet2!$F$3:$F$31="")*Sheet2!$G$3:$G$31)+SUM((Sheet3!$C$3:$C$68="HEO")*(Sheet3!$F$3:$F$68="")*Sheet3!$G$3:$G$68)+SUM((Sheet4!$C$3:$C$53="HEO")*(Sheet4!$F$3:$F$53="")*Sheet4!$G$3:$G$53)
 
C

Chris waller

Daniel,

The file is at work, so it will have to wait until Monday. Thanks once again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array Formulae 3
Sumproduct/Countif 7
Hyperlink via indirect cell reference 8
Formula Array Help in VBA 3
array question 2
Sumproduct and Array Formula 3
Desperately Need Excel Formula Help! 3
The cell currently being evaluated contains a constant 1

Top