Excel - Combining Statements
Hi, Apologies if this is answered elsewhere, i have searched and can't find anything similar..
I have a spreadsheet with multiple worksheets and data.
I have two statements which both work correctly and independently of each other, but when i try to combine them into one statement, the latter one is always ignored?
This is what i am using..
=SUM(COUNTIF('sheet 1'!H:H,"Priority 1"))
=SUM(COUNTIF('sheet 1'!G:G,">=-7"))
the first statement is counting all in column H that have the text 'Priority 1'.
The second statement then counts all in column G where the number of days open is less than or equal to 7 (this is a calculated field using =A1-Today() )
.. there are multiple version of this type of statement that i need to write.. only whenever i try to combine it always give the wrong answer!?
Any help greatly appreciated.. my head hurts.. :s
Thanks, C
Hi, Apologies if this is answered elsewhere, i have searched and can't find anything similar..
I have a spreadsheet with multiple worksheets and data.
I have two statements which both work correctly and independently of each other, but when i try to combine them into one statement, the latter one is always ignored?
This is what i am using..
=SUM(COUNTIF('sheet 1'!H:H,"Priority 1"))
=SUM(COUNTIF('sheet 1'!G:G,">=-7"))
the first statement is counting all in column H that have the text 'Priority 1'.
The second statement then counts all in column G where the number of days open is less than or equal to 7 (this is a calculated field using =A1-Today() )
.. there are multiple version of this type of statement that i need to write.. only whenever i try to combine it always give the wrong answer!?
Any help greatly appreciated.. my head hurts.. :s
Thanks, C
Last edited: